Question

SqlServer怎么把查询出来的结果整合集为一行？

代码如下：
SELECT COMPANY_ID,
CASE POST_TYPE WHEN '114801' THEN COUNT(*) END MANAGER_COUNT,
CASE POST_TYPE WHEN '114802' THEN COUNT(*) END CREDIT_COUNT,
CASE WHEN ISNULL(POST_TYPE,'') NOT IN ('114801','114802') THEN COUNT(*) END ELSE_COUNT
FROM T_M_MANAGERS WHERE COMPANY_ID =18 GROUP BY COMPANY_ID,POST_TYPE

目的：如上图，怎么把第二第三行的6,10整合到第一行里面对应的字段里面
跪求大神！
解决后再追加！

Answer 1

先得进行序号识别,用COUNT(*)语句.
再进行选择,用SELECT语句.

Answer 2

http://www.itfarmer.com.cn/878.html