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 vote366 views1 answer
Group by max date
SQL
0 vote346 views1 answer
Declare date variable sql
SQL
0 vote348 views1 answer
Restart sql server command line linux
SQL
0 vote391 views1 answer
Space not removing from column in sql
SQL
0 vote393 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
1 vote356 views1 answer
Continue in sql
SQL
0 vote336 views1 answer
Restore backup "text" postgresql command line
SQL
1 vote347 views2 answers
T sql get foreign key
SQL
0 vote355 views1 answer
Linebreak sql
SQL
0 vote379 views1 answer
Login failed for user sql server
SQL