how to check the 3rd max salary from an employee table?
Answers were Sorted based on User's Feedback
Answer / manish_patil
select sal from emp_sal where rownum = 3 order by sal desc
| Is This Answer Correct ? | 6 Yes | 9 No |
Answer / tushar
select max(sal) from ( select sal from emp group by sal order by sal) where rownum<4;
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / nagendra
select min(sal) from emp where sal in( select top 3 sal
from emp order by sal desc)
| Is This Answer Correct ? | 2 Yes | 6 No |
What programs use sql?
How do you explain an index number?
What does trigger mean in psychology?
Can we change the table name in sql?
Can you have a foreign key without a primary key?
how will i became good database developer?
How do I edit a stored procedure?
Can we join tables without foreign key?
Can we debug stored procedure?
Write a procedure to return the month and the number of developers joined in each month (cursor )
What is the sql case statement?
What are the topics in pl sql?
Oracle (3253)
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)