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

5 votes147 views4 answers
Select random rows sql
SQL
0 vote145 views1 answer
Changer un mot de passe mysql
SQL
0 vote147 views1 answer
Postgresql where clause not working
SQL
3 votes156 views1 answer
Sql is not like
SQL
0 vote152 views1 answer
Primary key multiple colums
SQL
0 vote151 views1 answer
Returning with sqlalchemy
SQL
0 vote174 views1 answer
Codigo crear tablas sql server
SQL
-1 vote127 views1 answer
Mysql if example
SQL
2 votes146 views2 answers
Sql first character
SQL
0 vote147 views1 answer
Exclude last comma separated string mysql
SQL