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
4574 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

Explain do view contain data?

938

Is primary key indexed by default in oracle?

928

How to download oracle database 10g xe?

957

How to convert characters to times in oracle?

953

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2215

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1590

How to use "if" statements on multiple conditions?

1108

how to clone 9i Database on to 10g Database.

2284

How to view the data files in the current database?

1037

What are the different types of record groups in oracle? Explain each of them

969

What is ordinary table in oracle?

1071

How to assign query results to variables?

1007

How to run queries on external tables?

985

What are the ansi data types supported in oracle?

893

what are bitmap indexes? How does they work?

2181