Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2010-03-17 : 08:28:27
|
| SELECT distinct A.MEDICATION_NAME,A.MEDICATION_Id,A.ENCOUNTER_ID FROM EMRMedication A LEFT OUTER JOINEMRMEDICATIONSSTATUSLKUP EMS ON A.STATUS = EMS.MEDICATION_STATUS_IDLEFT OUTER JOIN USERS USR ON USR.USER_LOGIN = A.USER_LOGIN LEFT OUTER JOINUSERS USSR ON USSR.USER_LOGIN = A.LAST_UPDATED_USERWHERE MEDICATION_TYPE = 'H' AND PATIENT_ID = '211516' AND STATUS!=0 ORDERBY MEDICATION_NAME ,MEDICATION_ID,ENCOUNTER_IDrows areNADIX ACUTAB DISPERTAB 300mg 2112162 2112180NADIX ACUTAB DISPERTAB 300mg 2112163 2112181SPARCIN TAB 200mg 2112161 2112180SPARCIN TAB 200mg 2112164 2112181UNICORT VIAL 100mg 2112165 2112181i want only one one record out of then what is the condition.onlu either one encounter and patient. |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2010-03-17 : 08:41:25
|
| use row_number function |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-17 : 08:42:18
|
| Remove DistinctUse min or max for A.MEDICATION_Id and A.ENCOUNTER_ID and group by A.MEDICATION_NAMEMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
duplicate problems