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

How can I see all tables in sql?

1009

Why do we use joins?

998

What is an exception in pl/sql?

1023

What is sql trigger example?

1019

how to drop an existing view in mysql? : Sql dba

1015

How to pipe multiline string to isql?

979

what are all the common sql function? : Sql dba

1022

What are sql injection vulnerabilities?

933

Can one improve the performance of sql*loader? : aql loader

997

How to install oracle sql developer?

1001

Why do we use set serveroutput on?

943

what is the use of friend function? : Sql dba

990

What is view? Can we update view

1374

How many commands are there in sql?

992

What is hibernate and its relation to sql?

1081