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

What are temporal data types in oracle?

1167

is there a tool to trace queries, like profiler for sql server?

1197

How to create a temporary table in oracle?

1331

Explain drop constraint oracle?

1121

What are the differences between number and binary_float in oracle?

1149

what is Single Byte Overhead...?

2613

What privilege is needed for a user to delete rows from tables in another schema?

1134

Explain oracle’s server parameter file.

1041

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1068

Please explain oracle left join with an example?

1095

Is oracle a programming language?

1037

How to convert dates to characters in oracle?

1092

How do we create privileges in oracle?

1100

What is control file used for?

1301

What are the numeric comparison operations?

1167