SQL query to pivot a column using CASE WHEN

by 
SELECT 
  name,
  SUM(CASE WHEN val = 1 THEN amount ELSE 0 END) AS amountVal1,
  SUM(CASE WHEN val = 2 THEN amount ELSE 0 END) AS amountVal2
FROM bank GROUP BY name

More Related Contents:

  1. SQL query rows as columns [duplicate]
  2. Efficiently convert rows to columns in sql server
  3. Convert Rows to columns using ‘Pivot’ in SQL Server
  4. Dynamic Pivot in Oracle’s SQL
  5. Simple way to transpose columns and rows in SQL?
  6. Oracle SQL pivot query
  7. How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
  8. SQL transpose full table
  9. Pivot on Multiple Columns using Tablefunc
  10. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  11. TSQL Pivot without aggregate function
  12. Dynamically create columns sql
  13. TSQL PIVOT MULTIPLE COLUMNS
  14. Pivot rows to columns without aggregate
  15. Dynamic Pivot Columns in SQL Server
  16. SQL Server : dynamic pivot over 5 columns
  17. SQL – How to transpose?
  18. How to pivot rows into columns (custom pivoting)
  19. Sql PIVOT and string concatenation aggregate
  20. The new PIVOT function in BigQuery
  21. How to create a PivotTable in Transact/SQL?
  22. How to replace (null) values with 0 output in PIVOT
  23. Pivot data in T-SQL
  24. PIVOT query on Distinct records
  25. SQL Server PIVOT perhaps?
  26. In SQL Server how to Pivot for multiple columns
  27. TRANSFORM and PIVOT in Access 2013 SQL
  28. Pivoting in DB2
  29. Advice Using Pivot Table in Oracle
  30. I need to know how to create a crosstab query

Leave a Comment