Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> cursor definition query
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
![]() |
![]() |