Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64568 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / purna chowdary
Select Sal From Emp A
WHERE 1=(Select Count(Sal) From Emp B
WHERE B.Sal>A.sal)
GROUP By Sal Desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How index is implemented in oracle database?
what is a Nested Loop join?
How to pass a parameter to a cursor in oracle?
How do I uninstall oracle 11g?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What do you mean by merge in oracle and how can we merge two tables?
How do you tell what your machine name is and what is its IP address?
How to find the duplicate rows count from employees table in oracle?
How to create an initialization parameter file?
What do you mean by merge in oracle and how can you merge two tables?
How to export your own schema?
Respected sir, Please send me technical questions related to oracle apps..
How can you merge two tables in oracle?
How to resolve name conflicts between variables and columns?
What is the usage of control file in oracle?
