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 votes146 views1 answer
Select count from table mysql
SQL
0 vote154 views1 answer
Postgresql replace html tags from string
SQL
6 votes207 views2 answers
Non relational database
SQL
2 votes131 views1 answer
Postgresql left join distinct on
SQL
16 votes144 views4 answers
Ascending order mysql
SQL
16 votes161 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
8 votes189 views1 answer
Insert a select statement into a table
SQL
0 vote155 views1 answer
How to find table lock and row lock in mysql
SQL
3 votes176 views1 answer
Mysql cli connect with password
SQL
0 vote138 views1 answer
Sql server udf performance
SQL