MySql数据库查询（四）

--排序查询

--可以使用 order by 语句，将查询到的结果按照某个字段进行排序;
--默认是升序 ASC
--降序DESC 
select from 表名 order by 字段

--按照金额从小到大显示
select id,name,money from zhangwu order by money;

--ASC升序，DESC降序 
--金额相同的id降序
select id,name,money from zhangwu order by money DESC,zid DESC;

--顺序问题 where limit order 
--where + order by
select id,name,money from zhangwu where money > 800 order by money;

--order by +LIMIT
select id,name,money from zhangwu order by money limit 6;

---where+order by +limit
select id,name,money from zhangwu where money>800 order by money limit 6;