How will you get 1 and 3rd and 5th records in table? What is the query in oracle?
Select * from
row_number() over (partition by emp order by sal) row_num from emp)ref
where row_num in (1,3,5);
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!