Skip to content

Instantly share code, notes, and snippets.

@phpdave

phpdave/GetColumnsAndNumberOfRows.sql

Last active August 29, 2015 14:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save phpdave/4438a76362d7e5d68c65 to your computer and use it in GitHub Desktop.
Save phpdave/4438a76362d7e5d68c65 to your computer and use it in GitHub Desktop.
Download ZIP
get coulmns and record count in 1 SQL query
Raw
GetColumnsAndNumberOfRows.sql
SELECT a.*, b.NumberOfRows
FROM MYTABLE a
CROSS JOIN (SELECT COUNT(*) AS NumberOfRows FROM MYTABLE) b
Raw
GetColumnsAndNumbersWithDifferentWhereClauses.sql
SELECT a.*, b.NumberOfRows
FROM MYLIB.MYTABLE1 a
CROSS JOIN
(SELECT COUNT(*) AS NumberOfRows FROM MYLIB.MYTABLE2 as c WHERE c.fieldc1=9999) as b
WHERE a.fielda1=9999
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment