find out the third highest salary?
- 92 Answers
- 129008 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / tejeswara rao potnuru
Find Out The Nth Highest Salary
SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL=&LEVELNO
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
Explain the use of compress option in exp command.
How to invoke the original export import utilities?
What is data type in oracle?
What are the oracle differences between nvl and coalesce
What privilege is needed for a user to create views in oracle?
How to define a specific record type?
What is connection pooling in oracle?
How to view the data files in the current database?
what is the difference between restoring and recovering?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to check the oracle tns settings?
How to execute the package in oracle?
How to create a new table in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
