select convert(varchar(30),cast(sum(je) as money),1) as aaa from test order by cast(sum(je) as money)
顺序应该是一样吧?select convert(varchar(30),cast(sum(je) as money),1) as aaa from test order by convert(money, sum(je))
select convert(varchar(30),cast(sum(je) as money),1) as aaa from test order by cast(aaa as money) asc
select cast(sum(cast(je as money)) as varchar(30)) as aaa from test order by sum(cast(je as money))
不好意思 我的问题没说明白 应是这样子的 select convert(varchar(30),cast(sum(je) as money),1) as aaa from test1 union select convert(varchar(30),cast(sum(je) as money),1) as aaa from test order by aaa在同一条查询记录里面 我显示 aaa 要字符型 排序时 aaa 要用 money类排序应怎么做??
from test
order by cast(sum(je) as money)
order by convert(money, sum(je))
应是这样子的
select convert(varchar(30),cast(sum(je) as money),1) as aaa from test1
union
select convert(varchar(30),cast(sum(je) as money),1) as aaa from test order by aaa在同一条查询记录里面 我显示 aaa 要字符型 排序时 aaa 要用 money类排序应怎么做??