具有COUNT个帮助的SQL子查询
我有一个有效的SQL语句SELECT * FROM eventsTable WHERE columnName='Business'我想把这个添加到子查询中…
COUNT(Business) AS row_count我该怎么办?
解决方案:
这可能是最简单的方法,尽管它不是最漂亮的方法:
SELECT *, (SELECT Count(*) FROM eventsTable WHERE columnName = 'Business') as RowCount FROM eventsTable WHERE columnName = 'Business'也可以使用,不用 group by
SELECT *,COUNT(*) OVER () as RowCount FROM eventsTables WHERE columnName = 'Business
页:
[1]