How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / sridhar
select gross_pay from tbl_payroll where gross_pay != (select
max(gross_pay) from tbl_payroll) limit 0,3
Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is difference between createstatement and preparedstatement?
What are the tool windows in sql server management studio? : sql server management studio
What is the fastest way to permanently delete a 1 million row table named customers?
What happens if time-only values are provided as date and time literals?
What is repeatable read?
What are “lost updates”?
Explain boyce and codd normal form(bcnf)?
How to create a large table with random data for index testing in ms sql server?
What are the results of running this script?
Explain about thread and memory management process of SQL?
Can we call stored procedure in view in sql server?
What are the purposes and advantages stored procedure?
What is scheduled job and how to create it?
What are parameterized reports?
How do I install sql server?