select DISTINCT cast(text字段 as varchar(max)) from PeisPatientExamItem where ID_PatientFeeItem = '228428'
貌似只能把字段一个个列出来了 select DISTINCT ID_PatientExamItem, ExamItem_Name_R, cast(ExamItemValues as varchar(max)) as ExamItemValues, cast(ExamItemValuesText as varchar(max)) as ExamItemValuesText from PeisPatientExamItem where ID_PatientFeeItem = '228428'
distinct
提示我
text 数据类型不能选为 DISTINCT,因为它不可比。
from PeisPatientExamItem
where ID_PatientFeeItem = '228428'
select
DISTINCT
ID_PatientExamItem,
ExamItem_Name_R,
cast(ExamItemValues as varchar(max)) as ExamItemValues,
cast(ExamItemValuesText as varchar(max)) as ExamItemValuesText
from PeisPatientExamItem
where ID_PatientFeeItem = '228428'