joshed-io/mod_count_check.sql

Created March 26, 2021 14:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/joshed-io/74b6429d2d16c8938b84d3980715225d.js"></script>
Save joshed-io/74b6429d2d16c8938b84d3980715225d to your computer and use it in GitHub Desktop.

Download ZIP

Proving the MOD function creates slices whose counts add up to the full count

Raw

mod_count_check.sql

	select count(*) from my_table where MOD(id, 10) = ANY('{0,1,2,3,4,5,6,7,8,9}'::int[]);
	-- 3296168

	select count(*) from my_table;
	-- 3296168

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment