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

how to find nth highest salary

Question Posted / seeman

Answer Posted / seeman

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between clustered and non-clustered indexes in ms sql server?

1001

What is the difference between count () and rowcount ()?

1026

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

988

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

981

What is the distinction amongst delete and truncate?

1071

How many types of functions are there in sql server?

946

How to round a numeric value to a specific precision?

1074

What are scalar functions in sql?

1144

How do users use Report Builder with SQL Server data sources?

155

Explain collation?

1063

What are the system database in sql server 2005?

1044

What are the methods used to protect against sql injection attack?

1065

What does COMMIT command do?

1063

How do you identify a foreign key?

1023

What is code near application topology?

279