Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150701 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 many anonymous blocks can be defined?
What the is the diff between local index and global index. give some example.
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How do I find my oracle client driver version?
How to concatenate two text values in oracle?
Please explain oracle data types with examples?
What is a data dictionary and how can it be created?
 What are the oracle DML commands possible through an update strategy?
How many types of tables are there in oracle?
Explain an index?
Is oracle a relational database?
how to do daily transactions with out sql* loader control file regesterd in apps?
How data locks are respected in oracle?
How do I connect to oracle database?
What is recovery manager in Oracle?
