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
- 4889 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
Can we save images in a database and if yes, how?
What is Redo Log Buffer in Oracle?
What are dml statements in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is a nvl function? How can it be used?
How to assign query results to variables?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What do database buffers contain?
How to start an oracle instance?
What are the uses of synonyms?
List out the components of logical database structure of oracle database.
How to experiment a data lock in oracle?
Can a formula column referred to columns in higher group ?
11. Display the client number and name and the client number and name of the person who referred that client.
