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

How many types of schemas are there?

1094

What is schemabinding a view?

973

How much memory that we are using in Logshipping Concept?

1845

Explain about analysis services?

1106

Can I disable or restrict ssrs export formats (rendering formats)?

155

Will the writetext statement activate a trigger?

1156

Can one drop a column from a table?

1069

How would you use user_constraints table in DB?

1061

How to recreate an existing index in ms sql server?

1119

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1156

What is partition index in sql server?

1175

Explain the difference between HTTP and HTTPS in database?

1098

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4463

How to create user messages with print statements in ms sql server?

1034

explain different types of constraints? : Sql server database administration

1004