Horje
stratified sampling sql Code Example
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



Sql

Related
alter column set not null to null postgres Code Example alter column set not null to null postgres Code Example
oracle change password expiration policy Code Example oracle change password expiration policy Code Example
mysql zerofill Code Example mysql zerofill Code Example
sqlalchemy existing db file Code Example sqlalchemy existing db file Code Example
python sqlalchemy connection show server Code Example python sqlalchemy connection show server Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 11



 

Horje