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

defination of bitmap index

2119

How to shutdown your 10g xe server from command line?

1084

What to do if the startbd.bat failed to start the xe instance?

1079

What is SQL Tuning Advisor in Oracle?

1175

Which are the five query types available in oracle?

949

What are the parameters that we can pass through a stored procedure?

1064

Describe the types of sub query?

993

what is reindexing?

1669

Explain an index?

1132

What is catalog in Oracle?

1362

What are the differences between blob and clob in oracle?

1089

What is PL/SQL ?

2054

what are bitmap indexes? How does they work?

2237

What are named parameters?

1088

How to write an inner join with the where clause in oracle?

1044