1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / krishnakumar

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data type in oracle?

566

What is clustered table in Oracle?

645

What is oracle used for?

536

6. Display the client name and order date for all orders using the traditional method.

1753

WHAT IS ecc 6.0

1666




can anyody please send me the dump for Oracle 10g certifications for DBA path?

1698

how may join possible between (requisition with purchase order)

1701

How to name query output columns in oracle?

692

What is flashback in Oracle?

582

What are the different types of database objects?

529

What is oracle update statement with inner join ?

585

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1541

What is data block in Oracle?

620

How many categories of data types?

577

What is user managed backup in Oracle?

615