SELECT A.SAL FROM TABLE A WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))

how to find nth highest salary

Question Posted / rabi

Answer Posted / rabi

SELECT A.SAL
FROM TABLE A WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
WHERE A.SAL<=B.SAL);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between delete and truncate statements?

1091

How to add more data to the testing table in ms sql server?

1105

Explain the steps to use transact-sql cursor?

1078

What is sub query and its properties?

983

What’s the use of custom fields in report?

952

What is always encrypted?

1012

Where views are stored in sql server?

999

What is nested transaction?

1111

What do you understand by replication in sql server?

1071

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1150

What is data modeling and Reterminal integrity?

1968

What is acid mean in sql server?

1133

Explain boyce and codd normal form(bcnf)?

968

How can a database be repaired?

1001

How to insert data with null values?

1046