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 |
master table and child table performances and comparisons in Oracle ?
What is a recycle bin in oracle?
Is oracle an operator?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How do you find current date and time in oracle?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
Where do we use decode and case statements?
Write a trigger example in oracle?
What is recycle bin in Oracle?
How to count duplicated values in a column in oracle?
Explain a private synonyms?
what is Table ?