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

34 votes274 views6 answers
Sql change data type
SQL
3 votes284 views2 answers
Postgres alter table owner
SQL
0 vote278 views1 answer
UNION ALL LEFT JOIN
SQL
6 votes282 views2 answers
Oracle
SQL
0 vote256 views1 answer
What is the essence of SQL?
SQL
0 vote274 views1 answer
See Foreign Key
SQL
0 vote297 views1 answer
ACCEPT nome PROMPT on oracle
SQL
1 vote306 views1 answer
Liquibase alter column type / length
SQL
1 vote272 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote249 views1 answer
Psql show with user is logged in
SQL