Posts by Icaro Solon • 1 point

• -2

  votes

  2

  answers

  9612

  views

  A: Select that takes the last 30 days from the current date

  To show the last 30 days, use: select to_date(to_char(sysdate-30,'dd/mm/yyyy'), 'dd/mm/yyyy') + rownum -1 AS data from all_objects where rownum <=…

  mysql sql

  answered 3 years, 6 months ago Icaro Solon 1