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 |
Can we use out parameter in function?
What is a record in a database?
What are reports usually used for?
What is range partitioning?
What is the difference between left join and right join?
what is 'mysqld'? : Sql dba
Which is faster union or join?
How many types of normalization are there?
What is index example?
Explain the difference between drop and truncate commands in sql?
How to avoid using cursors?
Why do we need unique key in a table?
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)