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

Point out the difference between user tables and data dictionary?

982

What is the disadvantage of User defind function?

2292

Is there any function in oracle similar like group_concat of mysql?

1053

if you ctreate table identity

2374

How to login to the server without an instance?

1162

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2183

Explain rename?

980

How do I reset a sequence in oracle?

1098

How to assign a tablespace to a users in oracle?

1048

What is a subquery?

1122

What is a sub query and what are the different types of subqueries?

1125

Can a parameter be passed to a cursor?

1126

what is normalisation?what are its uses?

2273

How to create an initialization parameter file?

1049

Where do you use decode and case statements?

993