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

12 votes286 views5 answers
Sql primary key
SQL
2 votes313 views3 answers
Sql server reseed identity column
SQL
0 vote314 views1 answer
Procedure excute monthly oracle
SQL
1 vote282 views1 answer
Get url of cpanel database hostname
SQL
1 vote291 views1 answer
Select inside insert query
SQL
0 vote291 views1 answer
Postgresql default value boolean
SQL
0 vote273 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
2 votes299 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote286 views1 answer
Postgresql log
SQL
0 vote305 views1 answer
Get a list of tables and the primary key
SQL