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 |
difference between bind variable and variable
Explain the use of grant option in imp command.
Is oracle a language?
How to write a query with a right outer join in oracle?
How to define an oracle cursor variable?
Which Oracle App Is Most Popular One ?
What is catalog in Oracle?
What is a nvl function? How can it be used?
How many types of segments in Oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to load data through external tables?
How to check the oracle tns settings?