Submit My Question - Recent Questions - Recent Answer

为什么以下2个sql语句的结果起不到排序的效果??

有一表:mytable
结构如下: ALL_RIGHT:number(8.3)

TOWN ALL_RIGHT HALF_RIGHT
-------------------------------------------------- ---------- ----------
富水镇 9.649 11.404
三溪镇 22.807 22.807

select * from mytable order by 'all_right' desc
select * from mytable order by 'all_right' asc

为什么以上2个sql语句的结果起不到排序的效果?

[390 byte] By [lghdragon-海] at [2007-12-16]

«« 有人用过CPRINTVIEW这个类吗?
»» 请问如何在XML中增加元素?

# 1

为什么加'号?
select * from mytable order by all_right desc;
select * from mytable order by all_right asc;

bzszp-SongZip at 2007-10-23 >