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 is package in pl sql with an examples?

1020

what are tables and fields? : Sql dba

1031

What are the types of index in sql?

1053

How to write a query to show the details of a student from students table whose

985

What are stored procedures used for?

990

Is sql a dbms?

981

give the syntax of grant and revoke commands? : Sql dba

1140

What are crud methods?

1017

Can we perform dml in function?

1054

Explain the update statement in sql

975

What is the use of double ampersand (&&) in sql queries? Give an example

1122

What does select count (*) mean in sql?

1005

How do I truncate a sql log file?

1053

How many types of tables are there?

936

How to display the records between two range in Oracle SQL Plus?

1136