pikonha/npercetage.sql

Created February 8, 2021 13:30

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/pikonha/f221158addcd0ddf18426986d7f59ab7.js"></script>
Save pikonha/f221158addcd0ddf18426986d7f59ab7 to your computer and use it in GitHub Desktop.

Download ZIP

Postgres select random N% of registers with condition

Raw

npercetage.sql

	-- This query is taking 10% of registers that met a simple condition
	select json_agg(id) from table
	where
	table.columnA is not null and
	random() < 0.1

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