我有以下三个不同的查询:
SELECT COUNT(*)
FROM [myDb].[dbo].[Properties] WHERE Bathtub is null
SELECT COUNT(*)
FROM [myDb].[dbo].[Properties] WHERE Bathroom is null
SELECT COUNT(*)
FROM [myDb].[dbo].[Properties] WHERE Toilet is null
我想在一个查询中查看其计数。我怎样才能做到这一点?谢谢。
使用子查询!了解SQL的一些基础知识https://blog.sqlauthority.com/
SELECT
(SELECT COUNT(*)
FROM [myDb].[dbo].[Properties] WHERE Bathtub is null) AS BathTub,
(SELECT COUNT(*)
FROM [myDb].[dbo].[Properties] WHERE Bathroom is null) AS Bathroom,
(SELECT COUNT(*)
FROM [myDb].[dbo].[Properties] WHERE Toilet is null) AS Toilet
警告如果您担心性能,可能会涉及开销
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句