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 |
How to get a create statement for an existing table?
Respected sir, Please send me technical questions related to oracle apps..
What is SQL access advisor in Oracle?
How to add a new column to an existing table with a default value?
What is literal?
Can you drop an index associated with a unique or primary key constraint?
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 ?
What is the difference between $oracle_base and $oracle_home?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
What is BBED in Oracle?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
What are synonyms used for ?