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

2 votes199 views3 answers
Replace null in sql
SQL
0 vote189 views1 answer
How many columns can be used for creating index?
SQL
0 vote202 views1 answer
Big table in mysql
SQL
4 votes193 views1 answer
Group by mysql and concatenate string
SQL
0 vote224 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote190 views1 answer
Mariadb number format
SQL
7 votes212 views2 answers
Where keyword sql
SQL
1 vote179 views1 answer
Deleting database in sql
SQL
13 votes144 views2 answers
Oracle all source
SQL
0 vote229 views1 answer
Mysql date equals to current_date plus days
SQL