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
- 4708 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 |
Point the difference between translate and replace?
Can the default values be assigned to actual parameters?
What is format trigger?
types of indexes and the rationale behind choosing a particular index for a situation.
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is meant by joins? List out the types of joins.
select * from emp what happened internally when we write this query in the sql prompt?
what is the difference between simple view and complex view?
Explain the difference between a procedure and a function?
How to create a temporary table in oracle?
What is the difference between I and G in Oracle?
What happens to the current transaction if the session is ended?
Oracle General 
