Oracle SQL Forum
May I know that how to show the 5th record first, then 1st - 4th, then 6th - last record in a select query?
Guys please share your valuable views i have tried all the option from my side, needs your experts views.
Thanks in advance.
Please check the below query in scott, if it'll work or not.
With employee1 as (select rownum rn, emp.* from emp)Select * from employee1 where rn=5Union allSelect * from employee1 where rn<5Union allSelect * from employee1 where rn> 5;
Sign up for STechies