select a.id from product a where (1= (select count(b.id) from product b wh

how to find nth highest salary

Question Posted / ajay kumar barik

Answer Posted / ajay kumar barik

select a.id from product a where (1= (select count(b.id)
from product b where b.id>=a.id))

It is for all database

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I find the sql server instance name?

1014

What are the differences between left join and inner join in sql server?

1157

How to connect sql server management studio express to sql server 2005 express?

1103

What is the difference between drop table and truncate table?

976

How to generate create procedure script on an existing stored procedure?

1068

What Are the Main Features of SQL Azure?

121

Can another user execute your local temporary stored procedures?

1027

Describe different Processing Modes offered by SSRS?

256

How many columns can exist together per table?

1211

Describe the functionalities that views support.

1149

What is the rdl file?

141

What does dml stand for?

998

What is federation member?

116

What is a primary key?

1000

What are the features of Embedded SQL

1175