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
- 9404 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
How do you find current date and time in oracle?
How to define a data source name (dsn) in odbc manager?
What is dynamic proxy?
what are actual and formal parameters?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is the exact use of Collections?
What is data file?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Explain the difference between a procedure and a function? What do you understand by those terms?
How to insert a new row into a table in oracle?
What is the difference between view and materialized view in Oracle?
What is oracle rowcount?
What is the relation of a user account and a schema in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
