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
- 4814 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 select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
What is Data Block ?
What is the difference between implicit index and explicit index?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
Explain an extent?
What is the relation of a user account and a schema in oracle?
Can we create more than one constraint to column ?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to insert multiple rows with one insert statement in oracle?
How are Indexes Update ?
Oracle General 
