Conditional Count on a field

by

I think you may be after

select 
    jobID, JobName,
    sum(case when Priority = 1 then 1 else 0 end) as priority1,
    sum(case when Priority = 2 then 1 else 0 end) as priority2,
    sum(case when Priority = 3 then 1 else 0 end) as priority3,
    sum(case when Priority = 4 then 1 else 0 end) as priority4,
    sum(case when Priority = 5 then 1 else 0 end) as priority5
from
    Jobs
group by 
    jobID, JobName

However I am uncertain if you need to the jobID and JobName in your results if so remove them and remove the group by,

More Related Contents:

  1. SQL QUERY COUNT THEN ADD
  2. How to use count and group by at the same select statement
  3. COUNT(*) vs. COUNT(1) vs. COUNT(pk): which is better? [duplicate]
  4. Fast way to discover the row count of a table in PostgreSQL
  5. Select count(*) from multiple tables
  6. Query with LEFT JOIN not returning rows for count of 0
  7. count(*) vs count(column-name) – which is more correct? [duplicate]
  8. SQL query for finding records where count > 1
  9. Compute percents from SUM() in the same SELECT sql query
  10. How to count instances of character in SQL Column
  11. SQL to Entity Framework Count Group-By
  12. Fastest way to determine if record exists
  13. SQL count(*) performance
  14. How to count the number of occurrences of a character in an Oracle varchar value?
  15. Count Returning blank instead of 0
  16. IN Clause with NULL or IS NULL
  17. Conditional SQL count
  18. How do I speed up counting rows in a PostgreSQL table?
  19. SELECT query with CASE condition and SUM()
  20. Run a query with a LIMIT/OFFSET and also get the total number of rows
  21. COUNT(id) vs. COUNT(*) in MySQL
  22. Query for count of distinct values in a rolling date range
  23. Truncate (not round) decimal places in SQL Server
  24. Selecting data into a Postgres array
  25. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  26. Calculate the number of records for each date between 2 dates
  27. What is causing Foreign Key Mismatch error?
  28. How to compare datetime with only date in SQL Server
  29. Generate random int value from 3 to 6
  30. scope_identity vs ident_current

Leave a Comment