Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 38657 Views
- IBM, I also Faced
- E-Mail Answers
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 |
How is debugging done?
What is sql keyword?
How many levels can subqueries be nested in a FROM clause?
what is the difference between truncate and drop statements? : Sql dba
Write a query to display the current date in sql?
what is the difference between sql and t-sql? : Transact sql
What are the parameter modes supported by pl/sql?
Is it possible to access the current value in a session before accessing next value?
How many types of literals are available in pl sql?
check whether all the emp numbers are indeed unique.
Explain the difference between sql and mysql.
How is sql used in oracle?
-
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)
