SELECT MIN(sal) FROM emp WHERE sal IN (select sal from emp order by sal d

find out the third highest salary?

Question Posted / vishawjeet saini

Answer Posted / vishawjeet saini

SELECT MIN(sal) FROM emp WHERE
sal IN (select sal from emp order by sal desc limit 3)

Its works on almost databases including postgres.

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

1) Does oracle have any table which contain all the exceptions and it's code internally?

1757

What is the use of oracle?

1036

What is the difference between a primary key & a unique key?

1097

How do I reset a sequence in oracle?

1108

How to use "while" statements in oracle?

1333

What is procedure overloading in oracle?

1066

Explain the difference between sql and oracle?

1088

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1052

What is a trigger oracle?

1096

What are the advantages of oracle?

1032

What does sharding mean?

1011

ABOUT IDENTITY?

2064

How to view existing locks on the database?

1058

How do I escape a reserved word in oracle?

1209

What is object data modeling?

971