Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 35 Answers
- 59407 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
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
How to convert a numeric expression from one data type to another?
What is unique key constraint?
What are the restraints imposed on the table design by a merge replication?
what protocol both networks use? : Sql server database administration
explain how to create a new schema in a database? : Sql server database administration
What are the steps you must follow to hide sql server instances?
How to rebuild indexes with alter index ... Rebuild?
What are the types of ssrs?
what method you can use to reduce the overhead of Reporting Services data sources?
How to list all schemas in a database?
What is table-valued sub query?
How to delete exactly duplicate records from a table?
How do you create a data source?
What is the difference between mysql and sql server?
how many bits ip address consist of? : Sql server database administration
