select * from tablename.aliasname where nth=select count(sal) from tablena

how to find nth highest salary

Question Posted / udathayadav

Answer Posted / udathayadav

select * from tablename.aliasname where nth=select
count(sal) from tablename where aliasname.sal<=sal

Is This Answer Correct ?

38 Yes

26 No

Please Help Members By Posting Answers For Below Questions

in the physical file layout, where should the transaction log be stored in relation to the data file?

939

Which are new data types introduced in sql server 2008?

987

Which tcl commands are available on the sql server?

1015

What is data source document?

977

Explain what are the restrictions that views have to follow? : SQL Server Architecture

988

What are the differences between lost updates and uncommitted dependencies?

1010

What are sql servers used for?

975

How and why use sql server?

952

Why we use the openxml clause?

952

What are the database objects? : SQL Server Architecture

983

What is SQL Azure Firewall?

134

What is function of ROLLUP ?

1032

What Are the Main Features of SQL Azure?

115

When to use null data driven subscription?

196

Explain what you mean by 3 tier architecture.

1015