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
- 58887 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
Can you explain various data region available in ssrs with their use?
Which are the important points to note when multilanguage data is stored in a table?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is difference between inner join and full join?
Explain different types of collation sensitivity?
Where in ms sql server is ’100’ equal to ‘0’?
What is a cube? : sql server analysis services, ssas
Define inner join? Explain with an example?
What is stored procedures?
Mention what are the core components of ssrs?
What is merge?
What are the different Topologies in which Replication can be configured?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is SQL Azure Data sync?
What are the different types of sub-queries?
