select Nth highest salary by using rownum
Answer Posted / siva kumar
select rownum,empno,ename,sal from(select * from emp order by
sal desc)group by rownum,empno,ename,sal having rownum='&n'
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is data sparsity and how it effect on aggregation?
How do you copy a database?
What do you understand by sub-queries in sql?
What is instance in dbms?
How to monitor firebird server activity?
dear sir please provide what question will be asked in bank it officer interview
what is storage manager?
Define database lock and its types.
What is third normal form?
What are the types of database?
What's the difference between file and database? Can files qualify as a database?
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.
What do you understand by fragmentation?
What are the advantages of a database?
What is dbms with example?