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
- 61266 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
What is logshipping and its purpose?
Which sql server is best?
What is bcp? When does it use?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is sql server query analyzer?
What is a fan-out query in SQL Azure?
What types of Joins are possible with Sql Server?
How do I uninstall sql server 2014?
How do I view a trc file?
How to find the login name linked to a given user name?
Does union all remove duplicates?
Define inner join? Explain with an example?
What are a scheduled jobs or what is a scheduled tasks?
What is report subscription?
What are SSL and TSL protocols?
