Interested to Buy Any Domain ? << Click Here >> for more details...
query to find the maximum no persons with same age(age
colomn) from emp table
- 1 Answers
- 4888 Views
- I also Faced
- E-Mail Answers
Answer / krishnakumar
select max_age,age
from
(select count(age) max_age,age from emp group by age order
by max_age desc)
where rownum < 2
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a Schema ?
How to define a sub function?
How to end the current transaction in oracle?
What is an oracle database table?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What are the commands youd issue to show the explain plan for select
What is a Shared SQL pool ?
How to login to the server without an instance?
Is there a combination of "like" and "in" in sql?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is SQL Tuning Advisor in Oracle?
Which database is better for os platform dependency?
Oracle General 
