we can get the solution for this queiry using 4 ways ...among 4 one solution is this
Type: Posts; User: Ramadurga Prasad; Keyword(s):
we can get the solution for this queiry using 4 ways ...among 4 one solution is this
select e.* from(select empname,sal,dense_rank()
over(order by sal desc) rank from emp) e
where e.rank>=3 and e.rank<=5;