>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement