我有一个有效的SQL语句 % e6 { [5 C. U/ FSELECT * FROM eventsTable WHERE columnName='Business'我想把这个添加到子查询中…) ?* j8 B5 U* K( f. K
COUNT(Business) AS row_count我该怎么办?/ d; W( }) Q- z1 S
3 e' j; N% b/ k* A" P4 W d/ h Q解决方案: 1 I6 G" w, @/ M4 g7 k+ S 这可能是最简单的方法,尽管它不是最漂亮的方法:, c% o9 n+ b5 ~$ z+ a
SELECT *, (SELECT Count(*) FROM eventsTable WHERE columnName = 'Business') as RowCount FROM eventsTable WHERE columnName = 'Business'也可以使用,不用 group by2 a j2 ?! w1 R1 W# E0 o9 ^
SELECT *,COUNT(*) OVER () as RowCount FROM eventsTables WHERE columnName = 'Business