交叉查询的sql

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

• ·初学Eclipse，完全沒接觸過eclipse
• ·提高 search_n 的性能
• ·AssemblyInfo.cs文件的作用。
• ·通过支持AT指令集的手机发送短消息（源代码）
• ·scanf()函数释疑（下）
• ·关于vc的mshflexgrid控件的用法（转
• ·scanf()函数释疑（上）
• ·贪食蛇（文本模式）
• ·JSP中的include的两种用法
• ·Linux的用户和用户组管理