SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP 3 salary FROM employee O

Find out the 3rd highest salary?

Question Posted / himanshu

Answer Posted / himanshu

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the primary key?

937

What is the file extension for sql database?

986

What is the difference between an inner and outer join?

1001

What is sql procedures and functions?

994

What is scope and visibility in PL/SQL?

1181

Is a table valued function object?

999

What is sql catalog?

1001

what are the disadvantages of mysql? : Sql dba

1132

What is record data type?

901

What is an inconsistent dependency?

1034

What is cursor and its types?

1050

Can a key be both primary and foreign?

983

How do you exit in sql?

1096

What sql database should I use?

1125

How many types of indexes are there in sql?

975