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 vote307 views2 answers
Find lowest number in sql
SQL
11 votes334 views3 answers
Pl sql example
SQL
1 vote347 views3 answers
Epoch to datetime
SQL
0 vote312 views1 answer
Mysql dump everythign
SQL
4 votes324 views2 answers
Sql server date now
SQL
0 vote304 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote322 views1 answer
Mysql select for update ejemplo
SQL
0 vote302 views1 answer
How to check if there is no database schema
SQL
0 vote300 views1 answer
Install ms sql server management studio
SQL
3 votes279 views1 answer
How to get list of synonyms in oracle
SQL