I was wondering how to get random rows within a SQL query since the full query has over 10 Billion rows and would explode our servers.
How can I query a subset which is sampled in this query structure?
SELECT
a,b,c
FROM test
WHERE
test.a= 123
AND test.b ILIKE '10008383825311900000'
LIMIT 1000000