Answers for "sql select random sample"

select random sql

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Posted by: Guest on January-11-2021

sql select random procentage from rows

-- for 10% -- 
SELECT * FROM table_name
	ORDER BY random() 
	LIMIT (SELECT (COUNT(*)*0.01)::INT FROM table_name);

Posted by: Guest on November-28-2020

Code answers related to "sql select random sample"