select * from table_name t1 where (n-1)= (select count(distinct(column

how to find nth highest salary

Question Posted / brahma

Answer Posted / brahma

select * from table_name t1 where (n-1)=
(select count(distinct(column_name)) from table_name t2
where t2.column_name>t1.column_name)

Is This Answer Correct ?

101 Yes

47 No

Please Help Members By Posting Answers For Below Questions

Which Model uses the SET concept

984

What is a mixed extent?

1025

What is @@rowcount in sql?

1005

what are acid properties? : Sql server database administration

997

How to trouble shoot if unable to connect SQL Server

1992

What are the 10 characteristics of data quality?

956

What is after dml trigger?

1016

How can I create a report based on a query? : sql server management studio

1015

What do you mean by collation recursive stored procedure?

1056

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1217

What is the largest component inside a field?

1128

How to use copy and concatenate commands in SQL?

1141

What are the advantages of policy management?

997

List the data types available in mssql?

1033

Explain some stored procedure creating best practices or guidelines?

937