how to find the second highest salary from emp table?
- 211 Answers
- 320894 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jude
first find first maximum
then easy to find second maximum
| Is This Answer Correct ? | 98 Yes | 330 No |
What is the use of non clustered index?
What is trigger in pl sql with examples?
What is constant in pl sql?
How does join work in sql?
what is the difference between trigger and constraint?
How do you delete duplicates in sql query using rowid?
How do I write a sql query in pgadmin 4?
Can we write dml inside a function in sql server?
suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.
7 Answers Geometric Software, IBM,
How to get each name only once from an employee table?
Why is sharding used?
What is the best sql course?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
