how to find nth highest salary
- 103 Answers
- 159043 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / aman kaushal
select salary from customer order by salary desc limit n,1;
here n is the array value 1st highest value starts with 0
value and then 1.
e.g
find the 2nd highest salary.
select salary from customer order by salary desc limit 1,1;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is temporary stored procedure?
What are the advantages of paper records?
when would you go for denormalization? : Sql server database administration
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is subquery in sql?
What is database black box testing?
How to create view in stored procedure sql server?
explain databases and sql server databases architecture? : Sql server database administration
Which database stores information about replication?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to create new tables with "create table" statements in ms sql server?
What is an indexed view?
How is foreign key related to primary key?
What is a covered index?
How to connect php with different port numbers?
