SELECT  distinct A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,CJRQ00,DBZBM0 
FROM  VW_ZS_DLKSBRXX  A WHERE 1=1
and (DQKS00=254 or DQBQ00=254 or YKSH00=254 or YBQH00=254) 
 ORDER BY RYCWH0