Stratified sampling sql

select d.*
from (select d.*,
             row_number() over (order by coursecode, newid) as seqnum,
             count(*) over () as cnt
      from degree d
     ) d
where seqnum % (cnt / 500) = 1;

Source: stackoverflow.com

Similar codes

1 vote185 views1 answer
Firebase bigquery cloud message
SQL
0 vote201 views1 answer
Mysql return column names when table is empty
SQL
0 vote184 views1 answer
Lister les index d'une table oracle
SQL
0 vote219 views2 answers
Mysql dump database tables only
SQL
0 vote209 views1 answer
Oracle merge insert if not exists
SQL
0 vote206 views1 answer
Query string starts with vowels
SQL
0 vote203 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote199 views1 answer
Create temporal table in sql
SQL
0 vote203 views1 answer
Sql string contains case sensitive
SQL
1 vote259 views1 answer
Hangfire clear all jobs
SQL