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 find the source of a table in sql server?

626


How to find the second highest salary of an employee?

682


What are various limitations of the views?

703


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

632


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

697






What is sql language?

625


Name some of the open source software that you can use in alternative to SSR?

121


Is the primary key column of a table an index in ms sql server?

622


How do I start sql server?

604


How can I change procedure name in sql server?

621


What is the stuff?

619


How can you check the version of sql server?

648


List out different types of normalizations in sql server and explain each of them?

635


What is the difference RDBMS and Graph Database?

702


Is foreign key a primary key?

587