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

Differentiate between post-database commit and post-form commit?

1049

Explain the types of exception?

1150

What language does oracle use?

1117

What is a view and how is it different from a table?

1059

What is a package ? What are the advantages of package ?

1093

What are the various types of snapshots ?

1033

What is merge in oracle?

1062

How to convert numbers to characters in oracle?

1036

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2023

What is the usage of save points in oracle database?

968

What happens if the imported table already exists?

1038

What privilege is needed for a user to create indexes in oracle?

1031

What is data block in Oracle?

1119

Explain about integrity constraint?

1133

Explain the difference between replace() and translate() functions in oracle?

1045