select a,b,c,d,e from tbl_name where c = (select max(c) from tbl

How can return max date row
A b c d e
1 2 1-mar-09 5 10
1 2 10-mar-09 5 10
Only using oracle predefined function. Not user defined.
Output:--
A b c d e
1 2 10-mar-09 5 10

Question Posted / sivaraman (gasc)

2 Answers
4594 Views
I also Faced
E-Mail Answers

Answer Posted / sivaraman (gasc)

select a,b,c,d,e from tbl_name where c = (select max(c)
from tbl_name)

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why packages are used in oracle?

1011

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.

3279

What is oracle used for?

981

How to select some columns from a table in oracle?

1018

What is hash cluster in oracle?

1105

Explain the difference between sap and oracle?

989

How to use existing values in update statements using oracle?

1022

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1948

How to filter out duplications in the returning rows using oracle?

990

What is rowid and rownum in oracle?

963

What is dynamic proxy?

969

How to convert characters to numbers in oracle?

1015

What are the limitations oracle database 10g xe?

989

Explain oracle’s server parameter file.

957

When do we use group by clause in a sql query?

1000