query to find the maximum no persons with same age(age colomn) from emp table

query to find the maximum no persons with same age(age
colomn) from emp table

Question Posted / srinu

query to find the maximum no persons with same age(age colomn) from emp table..

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

More Oracle General Interview Questions

What are the composite date types in oracle?

How many data types are supported?

What is the difference between SQL and SQL Server?

State some uses of redo log files?

What is the database name in oracle?

How to delete a user account in oracle?

a query to select maxmun 3 salaries of employee table

What is system global area (sga) in oracle?

what are Triggers?

What is the exact use of Collections?

How to omit columns with default values in insert statement in oracle?

What is transaction control statement and how many types of transaction control statement in Oracle?

For more Oracle General Interview Questions Click Here