Oracle select stmt

Greeting,

I have field1,field2 and field3 in tbl1. field3 is a date/time field with the following sample data.
I want to select the record which has the max(field3) and group by field1. Please suggest.

Field1    Field2   Field3
100        300       1-SEP-14
100        400       3-SEP-14
mrongAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
awking00Connect With a Mentor Commented:
select field1, field2, field3 from
(select field1, field2, field3,
 row_number() over (partition by field1 order by field3 desc) rn
 from yourtable)
where rn = 1;
0
All Courses

From novice to tech pro — start learning today.