W wphoenix1213 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-11 #1 怎么将表中字符类型的数据按数值大小排列?
王 王公子 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-11 #2 如果全是数字的话可以转换数字再排 如果不是的话你看一下order by fld能不能符合你的要求
W wphoenix1213 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-11 #3 to 王公子:是全是数字的,但是要怎么转换呢?
Q qianwt Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-11 #4 select convert(integer, field1) field1 form tablename order by field1
雪 雪中漫步 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-11 #5 SELECT * FROM table ORDER BY CONVERT(integer, 字段名)