Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> select most recent distinct of a composite value

select most recent distinct of a composite value

From: Gregory Bloom <Gregory.Bloom_at_gmail.com>
Date: 28 Jul 2006 15:45:47 -0700
Message-ID: <1154126747.129541.309740@h48g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US