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
- 4709 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is clustered table in Oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What are the attributes of cursor?
What privilege is needed for a user to create indexes in oracle?
Explain the use of rows option in exp command.
What is meant by raw datatype?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Can sub procedure/function be called recursively?
interview questions with answer for cts
what is port in oracle? how is it related to database application.
How to loop through a cursor variable?
What is flashback in Oracle?
Can we write dml statement in function in oracle?
What is MTTR advisor in Oracle?
Can we store images in oracle database?
