>I have a patient referrals table which identifies patients by field MNO and has a referral date field REFDATE. The table contains multiple records for each patient for each time the patient is referred:
>
>MNO REFDATE
>
>100 98.01.01
>100 98.03.02
>100 98.02.05
>101 98.01.05 (different patient)
>100 98.07.02
>
>Records are NOT necessarily added to the table in date order, but the table is indexed on REFDATE and related to the main patient table by MNO.
>
>Problem: I need a SELECT statement which will retrieve each MNO record and its latest REFDATE, i.e. in the example above it would be
>record 5. This statement is to list one record only per patient with the latest REFDATE only.
>
>Any ideas please?
Hi!
try this (aggregate function MAX):
select mno, max(refdate) from mytable group by mno
Srecko
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only