Select Salary From Employee Where rowid = n Order By Salary Desc;

how to find nth highest salary

Question Posted / divya

Answer Posted / divya

Select Salary
From Employee
Where rowid = n
Order By Salary Desc;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the disadvantages/limitation of the cursor?

966

Define left outer join?

976

What are the mathematical functions supported by sql server 2005?

1077

How to delete existing triggers using "drop trigger"?

1061

Explain primary key, foreign key and unique key?

998

What is trace flag in sql server?

1035

Is it safe to delete log files?

930

what is database replication? : Sql server database administration

1078

Do you know how to send email from database?

1015

How do I create an extended event in sql server?

960

What is log cache in sql server?

1053

What is the difference between composite index and covering index?

959

What is 1nf 2nf and 3nf?

897

What is PROJECTION Operation?

1030

difference between Clustered index and non clustered index ?

1004