select rownum,empno,ename,sal from(select * from emp order by sal desc)gr

select Nth highest salary by using rownum

Question Posted / siva kumar

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

Please Help Members By Posting Answers For Below Questions

What is data sparsity and how it effect on aggregation?

932

How do you copy a database?

919

What do you understand by sub-queries in sql?

945

What is instance in dbms?

865

How to monitor firebird server activity?

969

dear sir please provide what question will be asked in bank it officer interview

2121

what is storage manager?

926

Define database lock and its types.

979

What is third normal form?

914

What are the types of database?

921

What's the difference between file and database? Can files qualify as a database?

966

I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

2171

What do you understand by fragmentation?

910

What are the advantages of a database?

989

What is dbms with example?

1032