how to find the second highest salary from emp table?
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 'force view'?
What are the advantages of VIEW?
How do temporal tables work?
what are wild cards used in database for pattern matching ? : Sql dba
What is the different between Stored Procedure and Procedure?
Why are indexes and views important to an organization?
What is cursor and why it is required?
Give the structure of the procedure ?
How to select all records from the table?
What is a full join?
What is data type in sql?
What is cursor and its types?
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)