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!

Need to get oldest date?

User_SPVYVNov 23 2014 — edited Nov 24 2014

Hi:SQL and PL/SQL

I've a table like this. Need to get oldest datetime for each metricno. Need help

METRICNOTDATETAMOUNT
111/10/2014 9:13:14 AM1200.00
111/10/2014 9:13:23 AM100.00
112/10/2014 6:47:01 PM10000.00
121/10/2014 6:47:17 PM1100.00
121/10/2014 9:59:58 PM2000.00
123/10/2014 10:00:13 PM10000.00
137/10/2014 10:01:28 PM500.00
138/10/2014 10:03:08 PM1100.00

Output

METRICNOTDATETRANSFER_AMOUNT
111/10/2014 9:13:14 AM1200.00
121/10/2014 6:47:17 PM1100.00
137/10/2014 10:01:28 PM500.00

Thanks/Tanvir
This post has been answered by Etbin on Nov 23 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2014
Added on Nov 23 2014
6 comments
4,532 views