SELECT v.Emp_Sal FROM Employee_Test v WHERE 3= ( SELECT COUNT(DISTINCT

Find out the 3rd highest salary?

Question Posted / vivek

Answer Posted / vivek

SELECT v.Emp_Sal
FROM Employee_Test v
WHERE 3=
(
SELECT COUNT(DISTINCT z.Emp_Sal)
FROM Employee_Test z
WHERE v.Emp_Sal<=z.Emp_Sal
)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does subquery mean in sql?

1058

How bulk collect improves performance?

1011

Why trigger is used in sql?

976

What is pl sql block structure?

1044

What is difference between db2 and sql?

1006

What are the operators used in select statements?

1058

How do you explain an index number?

1111

What is rollback?

1118

What is set serveroutput on?

1139

what is log shipping? : Sql dba

1125

What are tables and fields in the database?

1113

what is online transaction processing (oltp)? : Sql dba

999

When is the explicit cursor used ?

1038

Why do we use %rowtype & %type in plsql?

1053

How do you get column names only for a table (sql server)?

1170