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

Home -> Community -> Usenet -> c.d.o.tools -> cursor definition query

cursor definition query

From: Ken Ho <hoke_at_gse.harvard.edu>
Date: 2000/07/21
Message-ID: <39789f5f.19486749@news.harvard.edu>#1/1

If I have a table whose columns are:

customer_ID varchar2(4)
visit_date date

and each customer has 1 or more visits, how would I select a single row for each customer_ID, with the stipulation that I must have the row with the most recent visit_date value? Received on Fri Jul 21 2000 - 00:00:00 CDT

Original text of this message

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