select salary from table t where n-1=(select distinct count (sal) from tab

how to find nth highest salary

Question Posted / affu

Answer Posted / affu

select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is store procedure? How do they work?

956

How do I setup a sql server database?

1004

do views contain data ?

913

Can primary key be a foreign key?

999

How many categories of data types used by sql server?

969

What is model database in sql server?

1004

What is perspective, have you ever created perspective? : sql server analysis services, ssas

860

What stored by the model? : sql server database administration

903

Why we use functions in sql server?

1012

Why use cursor in sql server?

1007

Explain user defined views?

913

Where the sql logs gets stored?

937

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

935

Why I am getting this error when renaming a database in ms sql server?

990

How can a user-defined datatype be created?

937