Counts on Changed data

by

Try this:

SELECT CONCAT('Change from ', OrgMatch, ' to ', ReMatchConfidence) AS Data,
Count(IF(Date="2017", 1, NULL)) as '2017', 
Count(IF(Date="2016", 1, NULL)) as '2016' 
FROM tables GROUP BY OrgMatch, ReMatchConfidence;

More Related Contents:

  1. Making a query with a single row out
  2. SQL IN Clause 1000 item limit
  3. How do you list the primary key of a SQL Server table?
  4. Calculating distance between two points (Latitude, Longitude)
  5. Passing an array of parameters to a stored procedure
  6. SQL Server : GROUP BY clause to get comma-separated values [duplicate]
  7. Return multiple columns of the same row as JSON array of objects
  8. Multiplication aggregate operator in SQL
  9. What’s the best way to join on the same table twice?
  10. How to log SQL statements in Grails
  11. The maximum recursion 100 has been exhausted before statement completion
  12. Delete duplicate records from a SQL table without a primary key
  13. Detect consecutive dates ranges using SQL
  14. MySQL equivalent of DECODE function in Oracle
  15. How do I select all the columns from a table, plus additional columns like ROWNUM?
  16. How can I use my sql knowledge with Cloudant/CouchDB?
  17. Why does SQL Server round off results of dividing two integers?
  18. How to Map Input and Output Columns dynamically in SSIS?
  19. Find the real column name of an alias used in a view?
  20. SQL Updating from an inner join
  21. Is it possible to query a comma separated column for a specific value?
  22. Venn Diagram for Natural Join
  23. What does a question mark represent in SQL queries?
  24. postgres – where in (list) – column does not exist
  25. incomplete information from query on pg_views [duplicate]
  26. How to create a pivot query in sql server without aggregate function
  27. SQL Server FOR XML Path make repeating nodes
  28. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  29. IIS connecting to LocalDB
  30. Fetch records that are non zero after the decimal point in PostgreSQL

Leave a Comment