一个SQL语句获得某人参与的帖子及在该帖得分总和
- WBOYOriginal
- 2016-06-07 17:57:06867browse
一个SQL语句获得某人参与的帖子及在该帖得分总和
select a.*,b.SumPoint from Expert_Topic_Index a,(select TopicID, Sum(Point) as SumPoint from expert_reply_index
where PostUserName = 'ghj1976'
Group by TopicID
Having Sum(Point) > 0
) as b
where a.TopicID = b.TopicID
这里其实就是把一个查询的结果放到新的一个查询中了。
另外 Having 对分组结果进行的查询。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：sql数据库不能直接用instr函数Next article：MDF文件在SQL Server中的恢复技术