例子1 排序boolean类型 CREATE TABLE `tab_b` ( `field` varchar(255) default NULL, `id` int(11) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `tab_b` VALUES ('1', 'ture'); INSERT INTO `tab_b` VALUES ('2', 'ture'); INSERT INTO `tab_b` VALUES ('3', 'false'); INSERT INTO `tab_b` VALUES ('4', 'false'); SELECT * from TAB_B ORDER BY field='true' desc 注意:ORDER by 后接的字段如果是boolean属性,则false比ture ‘大’!!!!! ######################################################## DROP TABLE IF EXISTS `tab_a`; CREATE TABLE `tab_a` ( `id` int(11) NOT NULL, `field3` int(11) default NULL, `field2` int(11) default NULL, `field1` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `tab_a` VALUES ('1', '1', '1', '1'); INSERT INTO `tab_a` VALUES ('2', '2', '2', '2'); INSERT INTO `tab_a` VALUES ('3', '3', '3', null); INSERT INTO `tab_a` VALUES ('4', '4', null, null); INSERT INTO `tab_a` VALUES ('5', '5', '5', null); INSERT INTO `tab_a` VALUES ('6', null, null, null); INSERT INTO `tab_a` VALUES ('7', null, null, null); INSERT INTO `tab_a` VALUES ('8', '8', null, null); SELECT * FROM TAB_A ORDER BY field1='' desc , field1 asc, field2='' desc , field2 asc, field3='' desc ,field3 asc 此处field1='' 可以看成boolean排序 desc 排序,field1=''为真的排在下面(因为看上面"注意"),否则排在上面(即field1!=''); 而后面的field1 asc相当于排序field1!=''数据,依次排序field2,field3..........
收藏
0人收藏
- 2017-12-11 17:37:06表变量,代替临时表 by xuleaper
- 2017-12-11 12:07:28触发器 by 吴红军
- 2017-12-10 10:06:58一条比较SQL by xuleaper
- 2017-12-09 13:48:24一个效率很高的汉字转拼音首字母的函数 by YuChao
- 2017-12-09 10:25:26字符串变表带有表头 by fengsweat
- 2017-12-08 12:56:04SQL求小于1000的所有水仙花数 by 二糊
- 2017-12-08 09:17:05Oracle统计表的数据行和数据块信息 by Merrill
- 2017-12-06 09:59:48PLSQL生成流水号 by xuleaper
- 2017-12-05 15:48:21oracle建表备份脚本,如果update的数据不对,可以从WEB_RI_PLYEDR_CED_BAK找回 by YuChao
- 2017-12-05 15:18:40分组合并多列 by 董一碗
- 2017-12-11 17:37:06表变量,代替临时表 by xuleaper
相关聚客文章