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 vote148 views1 answer
How to read the potentail error messages in ssis package
SQL
1 vote160 views1 answer
How to select random rows from a table
SQL
0 vote152 views1 answer
Full outer join in mariadb mysql
SQL
1 vote459 views1 answer
Mysql event last execution
SQL
103 votes317 views1 answer
Like sql
SQL
1 vote149 views1 answer
How to run parallel queries in sql server with entity framework
SQL
11 votes198 views5 answers
Update table from another table mysql
SQL
1 vote129 views1 answer
Setval pgsql
SQL
0 vote125 views1 answer
What is the essence of SQL?
SQL
0 vote131 views1 answer
Get only one row in mysql
SQL