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
- 4809 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 define a data field as not null?
Can you use a commit statement within a database trigger?
when i run my query on yesterday it is fast but today it is slow why?
what is null value?
How to find the duplicate rows count from employees table in oracle?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
when loggined as SYSTEM,how to display all the users of database using sql query?
How to drop an existing table in oracle?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
What happens to the indexes if a table is recovered?
How to export data to a csv file?
How to drop a tablespace?
Oracle General 
