这是我的MySQL表的快照:

有没有可能编写一个查询来获得这样一个数据透视表,比如output...

发布于 2012-09-29 19:31:34
您可以对此使用CASE语句来透视您的表。
SELECT url_host,
COUNT(CASE WHEN post_ID = -1 THEN 1 ELSE NULL END) Negative_One,
COUNT(CASE WHEN post_ID = 0 THEN 1 ELSE NULL END) Zero,
COUNT(CASE WHEN post_ID > 0 THEN 1 ELSE NULL END) Greater_Zero
FROM tableName
GROUP BY url_host发布于 2012-09-29 19:34:00
这样怎么样?
SELECT url_host,
SUM(CASE WHEN post_id = -1 THEN 1 ELSE 0 END) as post_id_minus1,
SUM(CASE WHEN post_id = 0 THEN 1 ELSE 0 END) as post_id_0,
etc...
FROM YOUR_TABLE
GROUP BY url_hosthttps://stackoverflow.com/questions/12652309
复制相似问题