Search
Search

Multiple counts in a single SQL query

debugcn Published at Dev
13
jason

I have these three distinct queries :

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

I want to see their counts in a single query. How can I do that? Thanks.

Kirk

Use Sub Queries! Learn some basics of 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

Warning Overheads involved in case if you are worried about performance

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Java

Multiple Counts with single query in mongodb

From Dev

MYSQL - Multiple counts in a single query

From Dev

multiple counts in single mysql query

From Dev

MYSQL - Multiple counts in a single query

From Java

How to get multiple counts with one SQL query?

From Dev

SQL Server Multiple Counts in the same Query

From Dev

create multiple counts in one SQL query

From Dev

Write custom SQL query for multiple counts

From Dev

consolidating multiple column counts into a single query with Rails 4 Activerecord

From Dev

Multiple counts in Sparql query

From Dev

mysql query (multiple counts)

From Dev

Multiple counts in Sparql query

From Dev

Creating an SQL query with multiple counts and different criteria from one table

From Dev

Linq to SQL to return multiple counts from query not returning correct results

From Dev

SQL Server - multiple counts in one query results issue

From Dev

Rails SQL Query counts

From Dev

Multiple counts on single grouped values

From Dev

Multiple counts on single grouped values

From Dev

SQL Server return multiple queries in a single query

From Dev

displaying multiple rows in single row in sql query

From Dev

SQL combining multiple select statements into a single query

From Dev

Multiple SQL statements in a single CakePHP query() call?

From Dev

PDO SQL single query, multiple rows and values

From Dev

SQL combining multiple select statements into a single query

From Dev

Sql query for multiple ANDs use in a single condition

From Dev

PL/SQL: Selecting multiple variables in a single query

From Dev

SQL Query to Transpose Column Counts to Row Counts

From Dev

Multiple months counts in one query

From Dev

multiple query report using counts

Related Related

  1. 1

    Multiple Counts with single query in mongodb

  2. 2

    MYSQL - Multiple counts in a single query

  3. 3

    multiple counts in single mysql query

  4. 4

    MYSQL - Multiple counts in a single query

  5. 5

    How to get multiple counts with one SQL query?

  6. 6

    SQL Server Multiple Counts in the same Query

  7. 7

    create multiple counts in one SQL query

  8. 8

    Write custom SQL query for multiple counts

  9. 9

    consolidating multiple column counts into a single query with Rails 4 Activerecord

  10. 10

    Multiple counts in Sparql query

  11. 11

    mysql query (multiple counts)

  12. 12

    Multiple counts in Sparql query

  13. 13

    Creating an SQL query with multiple counts and different criteria from one table

  14. 14

    Linq to SQL to return multiple counts from query not returning correct results

  15. 15

    SQL Server - multiple counts in one query results issue

  16. 16

    Rails SQL Query counts

  17. 17

    Multiple counts on single grouped values

  18. 18

    Multiple counts on single grouped values

  19. 19

    SQL Server return multiple queries in a single query

  20. 20

    displaying multiple rows in single row in sql query

  21. 21

    SQL combining multiple select statements into a single query

  22. 22

    Multiple SQL statements in a single CakePHP query() call?

  23. 23

    PDO SQL single query, multiple rows and values

  24. 24

    SQL combining multiple select statements into a single query

  25. 25

    Sql query for multiple ANDs use in a single condition

  26. 26

    PL/SQL: Selecting multiple variables in a single query

  27. 27

    SQL Query to Transpose Column Counts to Row Counts

  28. 28

    Multiple months counts in one query

  29. 29

    multiple query report using counts

HotTag

Archive