Answers for "sql select random procentage from rows"

SQL
0

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 procentage from rows"

Code answers related to "SQL"

Browse Popular Code Answers by Language