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

123 votes281 views5 answers
Sql where contains
SQL
0 vote105 views1 answer
Postgres where
SQL
8 votes89 views1 answer
Ltrim sql
SQL
0 vote114 views1 answer
Sql server synonym
SQL
1 vote117 views1 answer
Add time to date sql
SQL
0 vote104 views7 answers
10 random questions use python and SQL
SQL
0 vote106 views1 answer
Java check if something is in mysql table
SQL
2 votes156 views1 answer
Oracle trace session
SQL
1 vote95 views1 answer
Reutrn string after character sql
SQL
0 vote55 views1 answer
'0000-00-00' for column '
SQL