- 博客(3)
- 资源 (1)
- 收藏
- 关注
原创 分段统计函数(年龄分段)
SELECT CASEWHEN YEAR (CURDATE()) - YEAR (birthday) - ( RIGHT (CURDATE(), 5) < RIGHT (birthday, 5)) <= 10 THEN '[0-10)岁'WHEN YEAR (CURDATE()) - YEAR (birthday) - ( RIGHT (CURDATE(), 5) &l...
2018-07-29 15:46:16
5224
1
原创 sql 行转列实现
SELECT class_id, sum( CASE WHEN sex = '男' THEN 1 ELSE 0 END ) AS '男', sum( CASE WHEN sex = '女' THEN 1 ELSE 0 END ) AS '女'FROM studentGROUP BY class_id; ...
2018-07-29 14:55:45
155
原创 idea 激活地址
http://xdouble.cn:8888/(已验证)2018.1.5版本http://idea.youbbs.orghttp://idea.congm.inhttp://im.js.cn:8888http://intellij.mandroid.cn/http://idea.imsxm.com/http://idea.iteblog.com/key.phphttp://hb5.s.osidea...
2018-07-13 09:57:15
1645
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人