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

3 votes141 views1 answer
Null sql
SQL
0 vote144 views1 answer
Login failed for login due to trigger execution
SQL
0 vote122 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote136 views1 answer
T sql cursor tr
SQL
1 vote126 views2 answers
Mysql trim whitespace
SQL
2 votes144 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote90 views1 answer
Mysql convert column to uppercase
SQL
0 vote152 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote132 views1 answer
Inserting data into different tables at once in oracle sql
SQL
2 votes139 views2 answers
Mamp connect mysql terminal
SQL