Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> select most recent distinct of a composite value
I have a (huge) table with 30 columns, and three of those columns are
AREA_CODE, PREFIX, STATION, while another column is BILL_DATE. I want
to select only the records having the most recent BILL_DATE for each
distinct phone number (where phone number is a composite of
AREA_CODE+PREFIX+STATION). What would be the most efficient way?
Received on Fri Jul 28 2006 - 17:45:47 CDT