SELECT
COUNT (*)
FROM
table
WHERE
column2 > 10
UNION
SELECT
COUNT (*)
FROM
table
WHERE
column3 > 10
UNION
SELECT
COUNT (*)
FROM
table
WHERE
column3 > 10
UNION
结果:
(No column name)
155
433
931
如何将结果放入新列?
Column1 Column2 Column3
155 433 931
SELECT
(
SELECT
COUNT (*)
FROM table
WHERE column2 > 10
) AS [col1],
(
SELECT
COUNT (*)
FROM table
WHERE column3 > 10
) AS [col2],
(
SELECT
COUNT (*)
FROM table
WHERE column3 > 10
) AS [col3]
应该做的伎俩
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句