 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
sql： select gwlb， count(case when (year(getdate())-year(rybirthday)) between 20 and 30 then rygh end) as \\\'20-30\\\', count(case when (year(getdate())-year(rybirthday)) between 30 and 40 then rygh end) as \\\'30-40\\\', count(case when (year(getdate())-year(rybirthday)) between 40 and 50 then rygh end) as \\\'40-50\\\', count(case when (year(getdate())-year(rybirthday)) between 50 and 60 then rygh end) as \\\'50-60\\\', count(case when (year(getdate())-year(rybirthday)) between 60 and 70 then rygh end) as \\\'60-70\\\' from t_ry group by gwlb 返回类别: 教程 上一教程: MYSQL语法参考 下一教程: MYSQL安全性指南(3) 您可以阅读与"SQL交叉查询"相关的教程: · 谈谈SQL查询的BETWEEN · 一个实例讲解MYSQL查询优化 · MYSQL中如何实现TOP N及M至N段的记录查询？ · SQL连接查询 · 查询SQL碰到DEADLOCK问题的解决 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
