Interested to Buy Any Domain ? << Click Here >> for more details...
query to find the maximum no persons with same age(age
colomn) from emp table
- 1 Answers
- 4890 Views
- I also Faced
- E-Mail Answers
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 are the attributes that are found in a cursor?
What is index-organized table in Oracle?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
Is oracle a language?
What is a lookup table in oracle?
What is save point in oracle database?
what happened to the global index when I truncate the data in one of the partition?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
How to assign values to variables?
What is the difference between normal and corelated subqueries?
How to change program global area (pga) in oracle?
What is the function of Redo Log ?
Oracle General 
