how u can find the n row from a table?
Answer Posted / rishab
select emp_name,salary,rownum from
(select emp_name,salary,r from
(select salary,emp_name,rownum r from
(select salary,emp_name,rownum
from emp
order by salary desc)
order by r)
where r<4 ---- this number must be n+1
order by salary)
where rownum=1;
-- yes rownum=1 works...
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How do you declare a variable in pl sql?
What is primary key and unique key?
Is oracel sql developer written in java?
What is pl sql collection?
Can we update views in sql?
What is localdb mssqllocaldb?
How many rows can sqlite handle?
how can we optimize or increase the speed of a mysql select query? : Sql dba
what is 'mysqlshow'? : Sql dba
Why do we need view in sql?
What is lookup table in sql?
What is ttitle and btitle?
How would you pass hints to the sql processor?
how is myisam table stored? : Sql dba
How is data stored on a disk?