select '字段' ,GasUserID,DataDate,value1 from 表名
where GasUserID='1010200100002'
ORDER BY GasUserID,DataDate,Convert(decimal(18,2),Value1) desc
实现目标 3,4,5行数据符合要求,字段为一样的数字
select '字段' ,GasUserID,DataDate,value1 from 表名
where GasUserID='1010200100002'
ORDER BY GasUserID,DataDate,Convert(decimal(18,2),Value1) desc
实现目标 3,4,5行数据符合要求,字段为一样的数字