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 cpu pressure?

1046

How to transfer an existing table from one schema to another schema in ms sql server?

981

What are the difference between primary keys and foreign keys?

967

Tell me about builtinadministrator?

1001

how many layers of tcp/ip protocol combined of? : Sql server database administration

1000

How each E-R model constructs can be mapped to the relational model?

1006

Does the unique constraint create an index?

1063

Differentiate between a local and a global temporary table?

957

Differentiate between ms sql server reporting services vs crystal reports?

911

Explain how dts is used to extract, transform and consolidate data?

1000

Do you know what is lock escalation?

1014

What are the essential components of sql server service broker?

1020

What is normalization and what are the advantages of it?

987

Which trace flags are enabled in sql server?

1022

What area unit the various kinds of info compression introduced in sql server 2008?

1099