how to find nth highest salary
- 103 Answers
- 163891 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
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
Explain what is raid and what are different types of raid levels?
What are the different normalization forms?
What is extended stored procedures?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
Is there any difference between the primary key and unique key?
What are page splits?
Explain having clause and where clause?
What is serializable?
How to change the data type of an existing column with "alter table" statements in ms sql server?
How to get a list of columns in a view using the "sp_columns" stored procedure?
How to set database to be single_user in ms sql server?
How to enter comments in transact-sql statements?
What is the use of keyword with encryption.
What is a trace frag?
What is ssrs?
