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 vote190 views1 answer
Oracle sql copy table without data
SQL
0 vote189 views1 answer
Value of sold product using having and group by in sql
SQL
7 votes188 views2 answers
Create index mysql
SQL
0 vote193 views1 answer
Postgresql if else endif
SQL
10 votes214 views4 answers
Fetch first 5 characters of the string in sql
SQL
1 vote152 views1 answer
Mysql show attributes of a table
SQL
0 vote203 views1 answer
Sql mod even odd
SQL
0 vote169 views1 answer
Create date sql
SQL
0 vote189 views1 answer
Delete insert record in sql server
SQL
0 vote192 views1 answer
Exit psql
SQL