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 them (ethernet networks and token ring networks)? : Sql server database administration

982

What do mean by xml datatype?

1005

How to grant a permission in ms sql server using "grant execute" statements?

1022

Do you know the different ddl commands in sql?

993

Can sql servers linked to other servers?

971

How to create new databases with "create database" statements?

958

How to create view in stored procedure sql server?

957

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

907

What is update locks?

831

What are different types of raid levels?

1068

How to change the password of a login name in ms sql server?

959

What is the use of partition by in sql server?

882

How can we check the sql server version?

980

Explain about SQLOS?

945

How can we call UDF(User Define Function) using C# code in ASP.net ?

6795