how to find nth highest salary
Answer Posted / kavitha.r
Sorry. This one is correct
select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc) order by
salary asc
| Is This Answer Correct ? | 44 Yes | 18 No |
Post New Answer View All Answers
Why is the need for data conversion transformations?
What is policy based management (pbm)? : sql server database administration
What is the name of reporting services config file and what’s it’s used for?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Tell me what is use of except clause? How it differs from not in clause?
Define tool Manage Statistics in SQL Server 2000 query ?
What do you understand by mirroring?
Can a rule be bound to any column of any data type?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What are Row versions of DataRow?
What does man by sql wildcard characters in sql server?
What are the different ways you can create databases in sql server?
Do you know what is a linked server in sql server?
What are sp_configure commands and set commands?
How do you rebuild an identity column?