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

What is partition index in sql server?

1046

What is the difference between join and inner join?

952

Do you know what are different types of replication in sql server?

1032

What are magic tables in sql server?

1067

your distribution database is full what will u do

2123

What is an expression in ms sql server?

1007

how to use DTS package in 2000,2005,2008 in sql server

1783

What is ssrs?

117

Why do you need a sql server?

1027

Explain trigger classes i.e. Instead of and after trigger?

824

What are page splits? : SQL Server Architecture

933

Where sql server usernames and passwords are stored in a sql server?

930

What is SubQuery in SQL Server 2008

961

What do mean by xml datatype?

1004

List the different types of collation sensitivities in sql server?

972