随笔分类 -  Sql

交叉查询sql
摘要:sql: selectgwlb,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)... 阅读全文
posted @ 2004-12-17 14:23 张伦 阅读(774) 评论(0) 推荐(0)