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 vote186 views2 answers
Mysql two column combination unique
SQL
0 vote171 views1 answer
Stop psql server windows
SQL
0 vote184 views1 answer
What is logical database schema
SQL
-2 votes199 views2 answers
Union vs union all in sql
SQL
0 vote179 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote177 views1 answer
Executescalar in sql server
SQL
0 vote177 views1 answer
Sql count null as 0
SQL
0 vote206 views1 answer
Declare or use variable in snowflake
SQL
0 vote177 views1 answer
Mysql select where field is a value
SQL
10 votes193 views2 answers
Sql pagination offset
SQL