SQL ERDER BY & DESC
来源:互联网 发布:linux vim 向上查找 编辑:程序博客网 时间:2024/06/16 00:18
ORDER BY 语句用于对结果集合进行排序
ORDER BY 语句
OREDR BY 语句用于根据指点类对结果集进行排序
OREDR BY 语句默认按照升序排序,,,
如果需要降序对记录进行排序,可以使用DESC关键字
语法:
SELECT * FROM 表名 ORDER BY 列名
实例1: 以数字排序
SELECT * FROM account ORDER BY 密码
运行图:
实例2:以字母逆序 (z - a)
SELECT * FROM account ORDER BY 邮箱 DESC
运行图:
语法:两个查询条件之间用“,”隔开
实例3 : 数字顺序,并字母逆序
SELECT * FROM czhenya001 ORDER BY Age , `Name` DESC
阅读全文
1 0
- SQL ERDER BY & DESC
- mysql:sql order by */* desc (查询)
- sql order by,desc和limit使用(mysql)
- SQL函数学习 之 DENSE_RANK() OVER (PARTITION BY col2 ORDER BY col3 DESC) AS seq
- sql server row_number() over(partition by grower_pk order by a.pk_id desc)
- SQL中分析函数ROW_NUMBER() OVER(PARTITION BY GRADEOBJECTID ORDER BY BG.GRADEDATE DESC)的用法!!!
- Caused by: java.sql.SQLException: sql injection violation, syntax error: ERROR. token : DESC
- ORDER BY xxx DESC/ASC
- SQL cast desc
- SQL里desc和asc
- DESC[RIBE] (SQL*Plus command)
- PL/SQL不支持DESC命令
- row_number() over(order by col2 desc)用法
- sql2008 order by desc 查询速度慢
- 排序用法 order by asc desc
- desc
- row_number() over(partition by a order by b desc) rn
- row_number() over (partition by idno order by id desc)
- linux进程网络流量监控工具nethogs
- 微信小程序开发学习资料
- 2017 ACM-ICPC 亚洲区(乌鲁木齐赛区)网络赛 Query on a string(字符串+树状数组)
- T400安装linux mint后安装指纹驱动
- tomcat 配置-Dfile.encoding
- SQL ERDER BY & DESC
- 判断是否是在微信的内置浏览器里打开的网页
- 手机号归属地批量判断,106短信群发,1069短信营销,短信推广,公众号商城,号码区分,号码采集
- bzoj1863[Zjoi2006] trouble 皇帝的烦恼(二分+dp)
- LeetCode
- CSS里常见的块级元素和行内元素
- HDU 5976 逆元+打表+莫队
- OpenCV-二值图像连通域分析
- cookie是什么?php中cookie的设置和使用