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

Write a SQL query to make a column as unique?

1078

What is the use of builtinadministrators group in sql server? : sql server security

1108

System requirements for sql server 2005 express edition?

1070

what is blocking? : Sql server database administration

1088

What is a transact-sql statement?

1129

How to execute function in stored procedure sql server?

1234

Explain few examples of RDBMS?

1102

What do you understand by SQL*Net?

1085

Do you know the cursor types?

1205

What is etl - extraction, transformation, and loading?

960

How to use values from other tables in update statements in ms sql server?

1185

How to list all columns in a table using odbc_columns()?

1032

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1090

How to find the source of a table in sql server?

1037

How retrieve field names from the table in SQL through JAVA code?

1958