Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL distinct with max date

798995Mar 31 2011 — edited Mar 31 2011
I have in field1=item, field2=dates, field3=test results. There are several items in field1 and have several dates of when test results. I need to show only the last time that that the item was tested with test results showing also.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2011
Added on Mar 31 2011
3 comments
359 views