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

What are the dmvs? : sql server database administration

1003

List some major differences between triggers and stored procedures?

854

What do you mean by data manipulation language?

946

What is the difference between TRUNCATE and DROP?

1063

What is an execution plan? How would you view the execution plan?

1012

What are the advantages of paper records?

907

What is ems sql management studio? : sql server management studio

1035

how to use DTS package in 2000,2005,2008 in sql server

1784

What is a linked server in sql server?

1012

What stored by the msdb?

950

Do you know what is user defined datatypes and when you should go for them?

906

Why do we need different type of parameter?

997

What is spatial and temporal data?

927

What is dirty page?

918

What is the difference between an index and a unique index?

952