求SQL语句

Question

表     1               2                  3          4
       A               B                  C         001
       A               B                  C        -001
       A               B                  C         002 
       A               B                  C        -002转化成:       1               2                  3           4  
       A               B                  C          -002
       A               B                  C          -001
       A               B                  C           001
       A               B                  C          -002

Answer 1

应该这样吧：
      1               2                  3           4  
       A               B                  C          -002
       A               B                  C          -001
       A               B                  C           001
       A               B                  C           002

Answer 2

select * from yang where order by convert(int,字段4) desc

Answer 3

select 字段1,字段2,字段3,字段4 from 表 where order by convert(int,字段4) desc

Answer 4

select * from 表 
order by convert(int,字段4) desc

Answer 5

更改：
select 字段1,字段2,字段3,字段4 from 表 where order by convert(int,字段4)

Answer 6

select GARDEN,Z,LINE,NO from tpggxg41 where order by convert(int,NO)报错:服务器: 消息 156，级别 15，状态 1，行 1
在关键字 'order' 附近有语法错误。说明:字段NO类型"nvarchar"

Answer 7

ok了,把"where"取了就ok了!
谢谢各位了哈!