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

53 votes274 views6 answers
Sql server alter column
SQL
6 votes108 views2 answers
Mysql set primary key
SQL
6 votes102 views1 answer
Phpmyadmin reset root password
SQL
0 vote130 views1 answer
Implode in sql query
SQL
-1 vote109 views1 answer
Export mysql table to file
SQL
0 vote111 views1 answer
Postgres where
SQL
1 vote101 views2 answers
Mysql allow remote connections
SQL
13 votes97 views5 answers
Alter table query sql server change column
SQL
0 vote109 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
1 vote113 views2 answers
Datetrunc hour snowflake
SQL