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
- 4805 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 |
How to create a stored program unit?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
What is cluster Key ?
Difference between varchar and varchar2 data types?
What is hot backup and logical backup?
How to connect the oracle server as sysdba?
What is a cursor in oracle?
What are the types of trigger in oracle?
What is a package in oracle?
How to write a query with an inner join in oracle?
What is a system tablespace?
Oracle General 
