Interested to Buy Any Domain ? << Click Here >> for more details...
select Nth highest salary by using rownum
- 4 Answers
- 21558 Views
- Ford, TCS, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / welcomeashwin
SELECT * FROM HR.EMPLOYEES EMP1
WHERE &N=(
SELECT COUNT(DISTINCT(SALARY))
FROM HR.EMPLOYEES EMP2
WHERE EMP1.SALARY<=EMP2.SALARY
);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In which format data is stored in database?
What are the applications of database management system?
What is use of foreign key?
Explain atomicity and aggregation?
Is database a data structure?
What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....
What are the three types of databases?
Define union all operator and union.
Define a relation schema and a relation.
Name two utilities that oracle provides, which are use for backup and recovery.
What is data redundancy in dbms?
Why rdbms is called relational?
Describe reporting lifecycle?
Describe the four types of indexes.
Explain fully functional dependency?
