So I need to make a case where if between the year of popularity and the cutting-edge 12 months (sysdate) it's far 1 to five it will likely be rank 1 and six to 10 rank 2.
I use the code like this:
case trunc(months_between(sysdate, hire_date) / 12)
when between 1 and 5 then
when between 6 and 10 then
when between 11 and 15 then
end as information
Subscribe to get latest updates