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 vote254 views1 answer
GROUP BY postgres
SQL
13 votes250 views2 answers
Sqlite rename table
SQL
0 vote233 views1 answer
T sql check active deadlock
SQL
2 votes254 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote240 views1 answer
How to to get time in sql
SQL
0 vote241 views1 answer
Mysql grouping functions
SQL
0 vote246 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote269 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote205 views1 answer
Python escape string for sql
SQL
0 vote254 views1 answer
Sql how to get courses that i have made prerequisites
SQL