SQL查询排序问题？

[zhangw1978]

在SQL语句中怎样写根据某一字段进行排序查询的语句？

[wwwwb]

select * from tt orer by 字段

[vchao13]

select * from tableorer by 字段 desc asc/desc
desc是降序
asc是升序

[Ilovesport]

SELECT * FROMM TEST ORDER BY NAME ASC,ID DESC
ASC 升序
DESC 降序

[vchao13]

哦，不好意思写错了
是select * from tableorer by 字段 asc/desc
desc是降序
asc是升序

[Ilovesport]

晕，慢了。

[Ilovesport]

SELECT * FROM TEST ORDER BY NAME ASC,ID DESC
ASC 升序
DESC 降序

[OracleRoob]

--升序排列
select * from 表名 order by 字段 asc


--降序排列
select * from 表名 order by 字段 desc