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
- 60179 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajeev
select salary-1 from users where salary in (select
max(salary) from users);
| Is This Answer Correct ? | 0 Yes | 8 No |
Answer / ashish kumar
To find nth maximum salry
Select salary from tbl_name a where
n-1=(Select count(distinct(count(*))) from tbl_name b
where b.salary>a.salary)
| Is This Answer Correct ? | 10 Yes | 20 No |
Answer / gunjan sapra
select top 10 from tbl_name order by salary desc
| Is This Answer Correct ? | 4 Yes | 39 No |
Tell me what do we need queues in sql service broker?
What is the usage of sign function?
What is the difference between TRUNCATE and DROP?
What are the mathematical functions supported by sql server 2005?
how to define testing of network layers? : Sql server database administration
How do you test your database? : sql server database administration
What are the diifferences between the ms sql server vs mysql?
Is port 1433 secure?
How to delete a database in ms sql server?
Can truncate be rolled back?
What is the use of nvl work?
What is the difference between dbcc indexdefrag and dbcc reindex?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
