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 vote289 views1 answer
Select password from user mysql
SQL
0 vote300 views1 answer
Oracle gather table statistics
SQL
4 votes298 views3 answers
Mysql modify foreign key
SQL
0 vote324 views1 answer
Sql server Cost Fifo query
SQL
0 vote300 views1 answer
Mysql get last 2 month data
SQL
0 vote315 views1 answer
Oracle change password expiration policy
SQL
0 vote328 views1 answer
Mysql limit order by
SQL
-1 vote300 views1 answer
Ssql to lowercqse
SQL
4 votes308 views3 answers
Copy table postgres
SQL
1 vote292 views1 answer
Sql select where id not exists in another table
SQL