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

Which Model uses the SET concept

989

How to set database to be single_user in ms sql server?

1035

What is stretch database in sql server?

1069

What is the language structure to add a record to a table?

1025

What are the different types of collation sensitivity?

1129

What is the difference between a view and a stored procedure?

1039

What is the exact numeric data type in sql?

1005

What is clustered primary key?

1029

How many cores do I need for sql server 2016?

903

Difference between DELETE and TRUNCATE?

1054

How to delete exactly duplicate records from a table?

1064

Detail about query optimizer?

1111

What are the restrictions applicable while creating views? : SQL Server Architecture

1029

What is difference between inner join and full join?

1070

Explain what is meant by replication of database?

1035