latest date per group within 1 table

G

Guest

Hello this is my problem:
disk_name creation_date other data
mdr1 12-04-05 xxx
mdr2 25-03-05 yyy
mdr1 19-04-05 abac
mdr3 01-01-05
mdr1 21-02-05
mdr2 15-11-04 ybdr
… … …

How do I do to get per disk_name the latest created?
So output should be:
disk_name creation_date other date
mdr1 19-04-05 abac
mdr2 25-03-05 yyy
mdr3 01-01-05

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top