SELECT * FROM EMP A WHERE 7=(SELECT COUNT(SAL) FROM EMP WHERE A.SAL<SAL

how to find nth highest salary

Question Posted / kalai

Answer Posted / kalai

SELECT * FROM EMP A WHERE 7=(SELECT COUNT(SAL) FROM EMP
WHERE A.SAL<SAL)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

894

What are views in ms sql server?

1025

What is format parameter in ssrs?

136

Is it ok to shrink transaction log?

939

Explain about Joins?

938

How to generate create table script on an existing table in ms sql server?

1094

What is data block and how to define data block size?

980

What is the stuff and how does it differ from the replace function?

1008

How to create an multi-statement table-valued function?

943

What is SQL Azure Federations?

112

How many types of triggers are there?

1004

what is datawarehouse?

1057

Is the primary key column of a table an index in ms sql server?

920

How to use subqueries with the exists operators in ms sql server?

1060

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

950