Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153844 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / ajit
SQL QUERIES FOR FINDING Nth HIGHEST SALARY
SELECT DISTINCT (a.salary) FROM EMPLOYEES A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM EMPLOYEES B WHERE a.salary<=b.salary);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to write a query with a left outer join in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
How index is implemented in oracle database?
How to create lov dynamically at runtime & attach to text field?
How to store only time; not date and time?
What is connection pool in oracle?
What does sharding mean?
What is an oracle tablespace?
What is connection pooling in oracle?
What is a package ? What are the advantages of package ?
How to view the data files in the current database?
material view and view disadvantages?
How to use "if" statements on multiple conditions?
What is memory advisor in Oracle?
Explain the use of record option in exp command.
