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 vote292 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
3 votes265 views1 answer
Set default today mysql
SQL
0 vote270 views1 answer
Watch mysql command line
SQL
0 vote262 views1 answer
Mysqli last row
SQL
0 vote248 views1 answer
Mysql add to value
SQL
0 vote270 views1 answer
Mssql dockere
SQL
5 votes253 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote244 views1 answer
Docker export psql sql
SQL
0 vote246 views1 answer
Query to insert image
SQL
0 vote269 views1 answer
Csv to sqlite python
SQL