Interested to Buy Any Domain ? << Click Here >> for more details...
how to select second mauximum value in a given table under salary column
- 6 Answers
- 9572 Views
- Sapient, I also Faced
- E-Mail Answers
Answer Posted / utkal
Select distinct(E1.Salary) from EMPLOYEE E1 where 2 =
(Select Count(distinct(E2.Salary)) from Employe E2 where
E1.Salary <= E2.Salary).
Here n=2,
Similarily we can find the 5th highest salary etc...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a package in oracle?
What is define in oracle?
Please explain compound trigger in oracle?
How to connect ms access to oracle servers?
what is the scenario where you take the database to NoArchivelog mode?
How is it different from a normal table?
How to delete a user account in oracle?
Can objects of the same schema reside in different tablespace?
Can sub procedure/function be called recursively?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
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.
How many data types are supported?
What are the types of trigger in oracle?
What are the limitations oracle database 10g xe?
How to Truncate Table in Oracle
