SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT DISTINCT TOP 6 S

How to find 6th highest salary from Employee table ?

Question Posted / krishan kant

Answer Posted / krishan kant

SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 6 SALARY FROM EMPLOYEE ORDER BY SALARY
DESC)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is mysql the same as sql server?

986

What is 3nf normalization?

995

Where cross join is used?

961

Can you explain what is sql server english query?

996

How to write a query with a right outer join in ms sql server?

913

How do you manipulate data?

908

how many triggers you can have on a table? : Sql server database administration

976

What is the federation in sql azure?

What is page-level compression?

964

What is sql collation?

1209

Is sql server difficult to learn?

920

What is mean by dml?

1010

What are indexes in ms sql server?

1058

Which sql server is best?

993

What are the different types of triggers in SQL SERVER?

1138