SELECT min( sal ) FROM emp WHERE sal IN ( SELECT DISTINCT sal FROM e

how to check the 3rd max salary from an employee table?

Question Posted / danny

Answer Posted / danny

SELECT min( sal )
FROM emp
WHERE sal
IN (

SELECT DISTINCT sal
FROM emp
ORDER BY sal DESC
LIMIT 0 , 3
)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is pl sql block in dbms?

1055

Can we update views in sql?

990

Explain what is a view?

1118

What is the process of copying data from table a to table b?

1138

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1185

What is sql constant?

1104

What is consistency?

1187

What is the main reason behind using an index?

1060

Can we call a function containing dml statements in a select query?

1026

How do I run a script in sql developer?

1000

what is the difference between delete and truncate statement in sql? : Sql dba

1350

how to get a list of columns in an existing table? : Sql dba

1012

what are all the different types of indexes? : Sql dba

1107

what is a materialized view? : Sql dba

1133

Which constraints we can use while creating database in sql?

1121