Skip to content

Instantly share code, notes, and snippets.

@koi8-r

koi8-r/sql-agregate-null.sql

Created January 28, 2015 14:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save koi8-r/46d9fac4d8b1e62913b6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save koi8-r/46d9fac4d8b1e62913b6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql-agregate-null.sql
SELECT
COUNT(n), COUNT(m), COUNT(*)
FROM(
SELECT NULL AS n, 'n' AS m
UNION ALL
SELECT 2 AS n, 'n' AS m
UNION ALL
SELECT NULL AS n, 'n' AS m
UNION ALL
SELECT 4 AS n, 'n' AS m
UNION ALL
SELECT 5 AS n, NULL AS m
)x
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment