Conditional sum in Group By query MSSQL

by

Try

SELECT OrderId, 
       COUNT(*) ItemCount,
       SUM(CASE WHEN PriceType="CopyCost" THEN Price ELSE 0 END) TotalCopyCost,
       SUM(CASE WHEN PriceType="FullPrice" THEN Price ELSE 0 END) TotalFullPrice
  FROM OrderDetails
 GROUP BY OrderId

SQLFiddle

More Related Contents:

  1. How to compare clob columns of single table in oracle? [closed]
  2. Add a column with a default value to an existing table in SQL Server
  3. Table Naming Dilemma: Singular vs. Plural Names [closed]
  4. Simplest way to do a recursive self-join?
  5. generate days from date range
  6. A table name as a variable
  7. SQL Server – In clause with a declared variable [duplicate]
  8. How to set table name in dynamic SQL query?
  9. TSQL PIVOT MULTIPLE COLUMNS
  10. SQL ‘like’ vs ‘=’ performance
  11. How many rows in a database are TOO MANY?
  12. SQL to generate a list of numbers from 1 to 100
  13. SQL UPDATE order of evaluation
  14. SQL WHERE ID IN (id1, id2, …, idn)
  15. Aggregate function in SQL WHERE-Clause
  16. Fastest way to determine if record exists
  17. Group by date only on a Datetime column
  18. Finding the next available id in MySQL
  19. Error message: (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.)
  20. SQL – Query to get server’s IP address
  21. I keep getting the error “relation [TABLE] does not exist”
  22. Merge two rows in SQL
  23. How to concatenate many rows with same id in sql?
  24. PostgreSQL Where count condition
  25. Generate nested nth level JSON SQL Server using recursive CTE
  26. SQL Query To Obtain Value that Occurs more than once
  27. Where does the practice “exists (select 1 from …)” come from?
  28. SQL error: misuse of aggregate
  29. COUNT(id) vs. COUNT(*) in MySQL
  30. Join a count query on generate_series() and retrieve Null values as ‘0’

Leave a Comment