selectserialcode as 序号, starttime as 开始时间,endtime as 结束时间, casewhen commentresult =0 or commentresult = -1 then '未评价'when commentresult =1 then '非常满意'when commentresult =2 or commentresult =3 then '满意'when commentresult =4 then '不满意' end as 评价结果from TMP_CQ_Cmn_History where starttime between #00:00:00# and # 23:59:59# order by starttime desc这样试试
