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 difference between rank () row_number () and dense_rank () in sql?
What is meant by cursor in sql?
How would you hide a table in sql. ie the table can be only visible to its maker?
What is information schema in sql?
How do I enable sql encryption?
How to create a menu in sqlplus or pl/sql?
Why we use triggers in mysql?
What is a cursor for loop ?
how to findout the 100th maximum salary
discuss about myisam index statistics collection. : Sql dba
display records from 5 to 9 using rowid or rownum
Can we commit inside a trigger?
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)