资源描述:
《数据操纵的SQL语句及其执行结果说明》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、救据镰似的SWZ语句及曳执行箱皋说明:1.SELECTPatient•PatientName,Patient•PatientGender,Patient.PatientAge,/*InPatientAdmi.PFNo,*/Patient.PFNo,DoctorName,Symptoms,History,AllergicHistory,InitialDiagnosis,NurseNoFROMPatient,InPatientAdmi,MedicalAdvice,MedicalRecordsWHERE
2、Patient.PatientNo=InPatientAdmi.PatientNoandInPatientAdmi•PatientNo=MedicalAdvice•PatientNoANDMedicalAdvice•PatientNo=Medica1Records.PatientNo/*ANDPatient•PFNo=InPatientAdmi•PFNo*/ANDPatient.PatientNo=(SELECTPatientNoFROMWardDistributionWHEREBedNo=131
3、andWerdNo='WN0:m02');/*执行结果说明:PatientNamePatientGenderPatientAgePFNoDrNameSymptomsInitialDiagonsis冯帆男20PFN011005003李丹恶心头痛腹泻食欲不振。腹部疼痛胃病*/2.SELECTMedicalAdvice•MANo,MedicalAdvice•DoctorName,MedicalAdvice・MAdeTime,MedicalAdvice・NurseNo,MedicalExmm・TestRe
4、sult,TreatNAmGyDetailsOfTreat・TreatPeriodFROMMedicalAdvice,MedicalExam,DetailsOfTreatWHEREMedicalAdvice.MANoMedicalExam.MANoandMedicalExam・MANo=DetailsOfTreat・MANoANDMedicalAdvice・MANoIN(SELECTMANoFROMMedicalAdviceWHEREPatientName=1罗玉凤1AND/*datediff(d
5、ay,MadeTime,getdate())<=7*/MadeTimeBETWEEN*2010-04-2300:00:00fAND12010-05-0100:00:00');"执行结果说明:MANoDrNameMadeTimeNurseNoTestResultTreatNameTreatPeriodMAN0110042611王亚琼2010/4/26NN0101炎症特殊药物治疗10/04/27至10/05/4MAN0110042814王亚琼2010/4/28NN0104血压偏高血液透析10/04/2
6、9至10/05/6MAN0110050104王亚琼2010/5/1NN0102尿蛋白超标腹膜透析10/05/2至10/05/9*/3.SELECTPatientName,PatientAge,DepartNameFROMPatientWHEREPatientName=(SELECTPatientNameFROMMedicalAdviceWHEREMANo=(SELECTMANoFROMDetailsOfTestItemWHERE:EtemName='CT检查1ANDItemTimeBETWEEN*
7、2010-04-0100:00:00*AND‘2010-04-3000:00:00T/*MONTH(ItemTime)=MONTH(GETDATE()))*/));/*执行结果说明:PatientNamePetientAgeDepartName张涛45内科*/4.SELECTDrNo,DoctorName,COUNT(DISTINCTPatientNo)FROMMedicalExamGROUPBYDrNo,DoctorName;/*执行结果说明:DrNoDrNameNumberDN0101李丹2D
8、N0103王亚琼1DN0102曲乐;2★5.SELECT'住院费用:',SUM(ItemExpenses)FROMPatientFiles,FileDetailsWHEREPatientFiles・PFNo=FileDetails・PFNoandPatientFiles.PFNo=,PFN011004078!;/*执行结果说明:'住院费用'SUM(ItemExpenses)住院费用3174*/6.SELECTInPatientAdmi.PFNo,InPatientAdmi.Depa