ORDER BY关键字
来源:互联网 发布:淘宝企业开店费用 编辑:程序博客网 时间:2024/05/18 18:02
ORDER BY 关键字用于对结果集进行排序。
ORDER BY 关键字默认按照升序对记录进行排序。如果需要按照降序对记录进行排序,您可以使用 DESC 关键字。
语法:
SELECT column_name,column_name FROM table_name ORDER BY column_name,column_name ASC|DESC;
示例:
//从 "Websites" 表中选取所有网站,并按照 "alexa" 列排序:SELECT * FROM Websites ORDER BY alexa; //从 "Websites" 表中选取所有网站,并按照 "alexa" 列降序排序:SELECT * FROM Websites ORDER BY alexa DESC;
阅读全文
0 0
- 5、ORDER BY 关键字
- ORDER BY关键字
- mysql关键字讲解(join 、order by、group by、having、distinct)
- python dict order by key 字典关键字排序
- order by
- ORDER BY
- Order By
- order by
- ORDER BY
- order by
- ORDER BY
- ORDER BY
- order by
- order by
- order by
- order By
- group by order by
- group by + order by
- Ceres(4):Modeling Non-linear Least Squares APIs(1)
- 快速傅里叶变换(FFT)结果的物理意义是什么?(附Matlab程序)
- ios NSLocale 本地信息
- 11.1数组高级
- Python __call__
- ORDER BY关键字
- 背包问题 新手详解
- css3(1)
- Cause: org.postgresql.util.PSQLException: ERROR: cached plan must not change result type的前因后果
- 对发射的学习
- java-冒泡排序(使用比较器)
- 注解(Annotation)结构图
- IT运维工程师们为什么选择使用Linux系统
- JavaScript对象之正则表达式-RegExp