find n th highest salary replace n with 1,2,3....to find second,third,fourt

find the third highest salary?

Question Posted / imran ansari

Answer Posted / imran ansari

find n th highest salary replace n with 1,2,3....to find second,third,fourth........sal
SELECT sal from emp order by sal desc limit 2,1

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain isolation levels. : Transact sql

1015

What are hotfixes and patches?

886

explain mysql aggregate functions. : Sql dba

940

What is clause in sql?

1053

what does the t-sql command ident_current does? : Transact sql

928

When you have to use a default "rollback to" savepoint of plvlog?

1124

What are the sql aggregate functions?

1066

What does sql stand for?

944

what is the difference between union and union all? : Sql dba

974

What is pl sql block in dbms?

949

Is sql pronounced sequel or sql?

1213

What is cursor status?

1135

what is error ora-03113: end-of-file on communication channel?

1081

What are different sql data types?

954

How to set up sql*plus output format in oracle?

974