how to find the second highest salary from emp table?
- 211 Answers
- 322011 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
how to find the second highest salary from emp table?..
Answer / jude
first find first maximum
then easy to find second maximum
| Is This Answer Correct ? | 98 Yes | 330 No |
More SQL PLSQL Interview Questions
Temporary table vs Table variable in sql server?
Why self join is used in sql?
What is a sql profiler?
what are the advantages and disadvantages of views in a database? : Sql dba
What is crud sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What are sql functions? Describe the different types of sql functions?
What is t-sql? : Transact sql
difference between table level constraint and column level and advantages of table level constraint
What does truncate mean in sql?
How to avoid duplicate records in a query?
full outer join syntax
Categories
-
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)
