|
ianbauer
Starting Member
2 Posts |
 Posted - 10/09/2012 : 16:25:44
|
hello, I have been asked to answer this question and have no idea. can someone help me? I am told it is easy.
Assume we have loaded a flat file with patient diagnosis data into a table called “patientdata”. The table structure is:
Create table patientdata (
Firstname varchar(50),
Lastname varchar(50),
Date_of_birth datetime,
Medical_record_number varchar(20),
Diagnosis_location varchar(20),
Diagnosis_date datetime,
Diagnosis_code varchar(20))
The data in the flat file looks like this:
First Last date_of_birth Med Rec No Diag Loc Diag Date Diag Code
------- ------ ------------ ---------- ------------- ---------- ---------
'jane','jones','2/2/2001', 'MRN-11111','Mayo Clinic', '3/3/2009','diabetes'
'jane','jones','2/2/2001', 'MRN-11111','Mayo Clinic', '1/3/2009','asthma'
'jane','jones','5/5/1975', 'MRN-88888','Lahey Clinic','2/17/2009','flu'
'tom','smith','4/12/2002', 'MRN-22222','Lahey Clinic','3/3/2009','diabetes'
'tom','smith','4/12/2002', 'MRN-33333','Mayo Clinic', '1/3/2009','asthma'
'tom','smith','4/12/2002', 'MRN-33333','Mayo Clinic', '2/7/2009','asthma'
'jack','thomas','8/10/1991','MRN-44444','Mayo Clinic', '3/7/2009','asthma'
'jack','thomas','8/10/1991','MRN-44444','Lahey Clinic','3/16/2009','flu'
You can assume that no two patients have the same firstname, lastname, and date of birth combination.
Write a query that shows which of these patients were diagnosed in more than one location.
This problem has many solutions, but if you know SQL, you should be able to find one that uses a single query with no subqueries. |
|
Help please with simple query
