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
- 4780 Views
- I also Faced
- E-Mail Answers
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
How does Oracle guarantee data integrity of data changes?
What is a trigger and what are its types in oracle?
Give syntax for SQL and ORACLE joins.
What is the disadvantage of User defind function?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to drop an index?
What is a package ? What are the advantages of package ?
what is the dual table in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to update a table row with a record?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are a query and state the different types of queries and their uses?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to add a new column to an existing table in oracle?
