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 vote229 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote211 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote230 views1 answer
Sql commands in android
SQL
5 votes239 views1 answer
Oracle sysdate - 1 month
SQL
0 vote242 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote234 views1 answer
How to update sql server version
SQL
3 votes233 views2 answers
MySQL query to get column names
SQL
0 vote214 views1 answer
Generate sequence number in sql server
SQL
0 vote246 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote231 views1 answer
Sql server insert inner join
SQL