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

How to assign data of the deleted row to variables?

1055

How to install oracle odbc drivers?

1075

What do you mean by a tablespace?

1024

Explain the use of compress option in exp command.

999

What is a data dictionary and how can it be created?

1116

How do we create privileges in oracle?

1028

What are the differences between char and varchar2 in oracle?

1140

What exactly do quotation marks around the table name do?

949

How to convert a string to a date in oracle database?

1030

How to call a stored function in oracle?

1007

What are the parameters that we can pass through a stored procedure?

1046

Can you assign multiple query result rows to a variable?

964

How to lock and unlock a user account in oracle?

1079

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2211

What is logical backup in oracle?

997