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 |
What is the difference between sharding and partitioning?
Can a formula column be obtained through a select statement ?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
How do I manually uninstall oracle client?
What are the differences between blob and clob in oracle?
What is not equal to in oracle?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
How to change program global area (pga) in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.