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 sql basics?

992

Which join is like inner join?

978

Can we call dml statement in function?

979

Explain the difference between triggers and constraints?

921

What are triggers and its types?

996

how many sql ddl commands are supported by 'mysql'? : Sql dba

959

Is sql injection illegal?

964

How does postgresql compare to oracle/db2/ms sql server/informix?

983

What is varchar sql?

1060

Which sql statement is used to delete data from a database?

898

What is the difference between database trigger and stored procedure?

1008

What are the different types of dbms?

956

What is Collation Sensitivity ? What are the various type ?

906

Explain the types of joins in sql?

966

What are the sql commands?

1099