how to find nth highest salary

Answer Posted / divya

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

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete multiple rows with one delete statement in ms sql server?

519


How to retrieve error messages using mssql_get_last_message()?

533


What is the default order of an order by clause?

584


What is user-defined function?

569


How to create user defined functions with parameters?

644






What are the tables in sql?

626


How do I view a script in sql server?

533


Explain what is use of dbcc commands?

511


What is index in an assignment?

530


What are constraints?

588


What is snapshot replication?

599


What are the types of subscriptions in SQL Server replication?

550


What are rest-style architecture's?

149


What are the different sql server versions?

519


List the advantages of using stored procedures?

563