Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150678 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / bhagayraj
SELECT *
FROM Emp e1
WHERE (2) = (
SELECT COUNT(DISTINCT(e2.Salary))
FROM Emp e2
WHERE e2.Salary > e1.Salary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a system tablespace and when it is created?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
what is IDE,DMV in sql server?
 What are the oracle DML commands possible through an update strategy?
How are extents allocated to a segment?
Explain the difference between sql and oracle?
How to define a procedure inside another procedure?
What is an anonymous block?
Explain the use of constraints option in exp command.
How to do a full database export?
What is sequence?
What do you mean by redo log file mirroring?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Is there an oracle sql query that aggregates multiple rows into one row?
