Min(date)

brucezepplin · #1 (**permalink**) 08-02-11, 10:48

Hi, I have a database with user defined dates in it for when a person has gone into hospital (admis_date). What I am looking to do is to find the first time a person was admitted to hospital only. ie if a person has attended a clinic for influenza 5 times in their life, i only want to pick out the first time. I have

Code:

SELECT DISTINCT Person, MIN(Admis_Date) AS FIRST_DATE, Diagnosis
FROM DATABASE A
WHERE Diagnosis = "influenza"

but this returns all instances of influenza for everyone in the database. Whats going on?

brucezepplin · #2 (**permalink**) 08-02-11, 11:00

it's ok i;ve fixed it.

sathyaram_s · #3 (**permalink**) 08-02-11, 11:41

How? Would you mind sharing the solution

----

Internet Services

Web Development

Digital Marketing

Consumer Tech