Horje
sql random sampling per group Code Example
sql random sampling per group 
with randomly_sorted_users as (

    select
        user_id,
        signup_date,
        row_number() over(partition by date_trunc('year', signup_date)
                            order by random()) as random_sort
    from
        user_table

)
select
    user_id,
    signup_date
from
    randomly_sorted_users
where
    random_sort <= 5
Source: stackoverflow.com



Sql

Related
create procedure with encryption Code Example create procedure with encryption Code Example
inner join php my admin Code Example inner join php my admin Code Example
sql find column name like Code Example sql find column name like Code Example
"azure mysql purge binary logs" Code Example "azure mysql purge binary logs" Code Example
moodle query item quiz Code Example moodle query item quiz Code Example

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



 

Horje