how to find nth highest salary
Answer Posted / nidhish
replace the N with wat ever number u want
select min(salary) from employee where salary in ( select
distinct top N salary from employee order by salary desc)
| Is This Answer Correct ? | 26 Yes | 17 No |
Post New Answer View All Answers
How will you know when statistics on a table are obsolete?
How to end a stored procedure properly in ms sql server?
What are the elements of dbms?
How to create new tables with "create table" statements in ms sql server?
What happens when the SQL Azure database reaches Max Size?
What is a transactions?
how many bits ip address consist of? : Sql server database administration
How to retrieve error messages using mssql_get_last_message()?
What are the different types of data sources in ssrs?
What are the types of subquery?
What is exporting utility?
Write a SQL queries on Self Join and Inner Join.
How would you go about developing a ssrs report?
How to find the login name linked to a given user name?
What is RAID? What are the different types of RAID configurations?