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

1 vote144 views1 answer
Oracle list data files
SQL
0 vote148 views1 answer
Logtash mysql cofiguration file
SQL
3 votes151 views4 answers
Show databases in sql server
SQL
1 vote136 views1 answer
Mysql login console
SQL
0 vote252 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote195 views1 answer
Postgresql find biggest table
SQL
1 vote140 views2 answers
Mysql spring boot application.properties
SQL
0 vote195 views1 answer
Doctors appointment
SQL
0 vote140 views1 answer
Cast for print sql
SQL
8 votes183 views1 answer
Racle create auto increment column
SQL