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 |
sql query to get zero records from a table
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
when i run my query on yesterday it is fast but today it is slow why?
State the various uses of dbcc command?
What is STATSPACK tool?
How to increment dates by 1 in oracle?
What are the uses of synonyms?
How to define a variable of a specific record type?
What is a package in oracle?
what is trigger?
Define 'view' advantage ?
How can we find out the current date and time in oracle?