SELECT case when isnull(CHICUN1, '') <> '' and convert(float,CHICUN1)<convert(float,CHICUN1LSL) then convert(float,CHICUN1LSL)-convert(float,CHICUN1) when isnull(CHICUN1, '') <> '' and convert(float,CHICUN1)>convert(float,CHICUN1USL) THEN convert(float,CHICUN1)-convert(float,CHICUN1USL) else 0 END AS C1, convert(float,CHICUN1USL)-convert(float,CHICUN1LSL) AS 差值1 FROM Table1这个查出来是这样的我有C1到C60差值1到差值60想这样以两列的形式放在一起C1对应差值1这样以此类推SQLSERVER的在查询里面这样放在一起