oracle query to retrieve closest and second closest future date based on the current date -
i want retrieve closest , second closest future date based on current date. example : current-date=28-07-2017
dates retrieve
28-07-2017 29-07-2017
or followed top 2 dates closest current date.
plzz me out in writing query in oracle
try this:
select sysdate,sysdate + level "dates" dual connect level <= 1 ;
Comments
Post a Comment