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

0 vote328 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote334 views1 answer
Sql reverse order of results
SQL
0 vote363 views2 answers
Postgres isnull
SQL
0 vote336 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
1 vote329 views1 answer
Psql client write to bash variable
SQL
0 vote317 views1 answer
Components/Fields of Internal Table
SQL
0 vote342 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote318 views1 answer
Oracle flush Shared Pool
SQL
0 vote343 views1 answer
Sql column contains special character
SQL
1 vote372 views1 answer
Drop colum oracle 18c
SQL