mysql 返回的查询结果为空 (即零行)._当 MySQL 返回的查询结果为空(即零行)的时候 结果表示0...

满意答案

lxvtag

2013.09.09

采纳率：48%    等级：12

已帮助：5206人

SELECT

a.update_date,

a.user_id,

a.news_id,

(CASE WHEN b.counter IS NULL THEN 0 ELSE b.counter END) as 'Counter'

FROM (

SELECT update_date, user_id, news_id

FROM t_comment

GROUP BY update_date, user_id, news_id) a

LEFT OUTER JOIN

(

SELECT update_date, user_id, news_id,

count(*) AS counter FROM t_comment

WHERE user_id = 2 AND news_id = 15

GROUP BY user_id, news_id

) b

ON a.update_date = b.update_date

AND a.user_id = b.user_id

AND a.news_id = b.news_id

GO

T-SQL实现，原理如上，未经测试。祝你好运。

00分享举报