Interested to Buy Any Domain ? << Click Here >> for more details...
find the third highest salary?
- 23 Answers
- 44325 Views
- I also Faced
- E-Mail Answers
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 |
How is indexing done in search engines?
Do we need commit after truncate?
how to enter numeric values as hex numbers? : Sql dba
What are the types of join and explain each?
What are Lexical Parameters.How They are used in Reports 6i
Can we use commit inside a trigger?
Why use truncate instead of delete?
Is progress software supports to ( pl/sql )?
How to fix oracle error ora-00942: table or view does not exist
What are two statement types in sql?
Find out the 3rd highest salary?
51 Answers BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,
Can triggers stop a dml statement from executing on 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)
