find the third highest salary?
Answers were Sorted based on User's Feedback
Answer / justin
SELECT sal FROM empORDER BY sal DESC LIMIT 2 , 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / purushotham
select level,max(sal)
from table
where level=3
connect by prior sal>sal
group by level
| Is This Answer Correct ? | 0 Yes | 6 No |
Answer / mousumi dalai
select min(sal) from emp where sal in
(select sal from emp order by sal desc where ROWCOUNT <=3) ;
| Is This Answer Correct ? | 9 Yes | 36 No |
Is there a 64 bit version of ssms?
Name the operator which is used in the query for pattern matching?
Can you have multiple SPs with the same name on a database?
What are sql indexes?
Are stored procedures compiled?
What is graph sql?
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
When the mutating error will comes? and how it will be resolved?
From an Employee table, how will you display the record which has a maximum salary?
29 Answers Cap Gemini, Exilant, Synechron,
Give me some examples of predefined exceptions.
what is the difference between nested subquery and correlated subquery?
How do I count rows in sql?
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)