Count based on condition in SQL Server

by

Use SUM/CASE…

SELECT
    COUNT(*),  --total
    SUM(CASE WHEN name="system" THEN 1 ELSE 0 END) --conditional
FROM
    myTable

More Related Contents:

  1. SQL where clause odd behavior [closed]
  2. How do I escape a single quote in SQL Server?
  3. Simple way to transpose columns and rows in SQL?
  4. Only inserting a row if it’s not already there
  5. Unpivot with column name
  6. Selecting data from two different servers in SQL Server
  7. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  8. SQL JOIN vs IN performance?
  9. Most efficient way in SQL Server to get date from date+time?
  10. Convert varchar into datetime in SQL Server
  11. TSQL Pivot without aggregate function
  12. How to generate a range of dates in SQL Server
  13. SQL RANK() versus ROW_NUMBER()
  14. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  15. SQL : BETWEEN vs =
  16. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  17. How do I perform a GROUP BY on an aliased column in SQL Server?
  18. How do I make a composite key with SQL Server Management Studio?
  19. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  20. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  21. Alter user defined type in SQL Server
  22. Best equivalent for IsInteger in SQL Server
  23. Store multiple bit values in a single table column
  24. Syntax of for-loop in SQL Server
  25. SQL Server equivalent to MySQL enum data type?
  26. SQL – Call Stored Procedure for each record
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Group consecutive rows of same value using time spans
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment