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 vote207 views1 answer
How to move a columns location in mysql
SQL
0 vote186 views2 answers
Mysql regexp match word
SQL
3 votes183 views1 answer
Sql timestamp to date
SQL
0 vote204 views1 answer
Psql generate id in existing database
SQL
7 votes216 views2 answers
Phpmyadmin change password
SQL
0 vote199 views1 answer
Sql case sttement with set
SQL
0 vote194 views1 answer
Incorrect string value: mysql
SQL
5 votes249 views2 answers
How to ascending order in sql
SQL
0 vote189 views1 answer
How to find top 3 salary in sql
SQL
6 votes199 views2 answers
If not exists insert sql
SQL