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 vote251 views1 answer
Sql query for getting data with join and count
SQL
0 vote287 views1 answer
View t-sql mail configuration
SQL
1 vote281 views1 answer
Check current sequence value postgres
SQL
0 vote249 views1 answer
Sql server update top n records
SQL
2 votes278 views1 answer
Oracle sql merge
SQL
16 votes316 views1 answer
Mysql mediumint max value
SQL
0 vote265 views3 answers
Sql server import json
SQL
0 vote265 views1 answer
Sql trying to delete database in use
SQL
0 vote261 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
7 votes270 views6 answers
Group_concat mysql
SQL