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 vote200 views1 answer
Laravel eloquent get generated sql
SQL
0 vote207 views2 answers
Pop sql insert value into
SQL
0 vote223 views1 answer
Excel vba import data to sql server
SQL
5 votes193 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote211 views1 answer
Create mysql pool connection python flask
SQL
0 vote195 views1 answer
Php delete database
SQL
-1 vote195 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote207 views1 answer
Sql server user permissions and roles
SQL
0 vote233 views1 answer
Mysql preg replace
SQL
14 votes215 views5 answers
Sql oracle limit
SQL