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

Similar codes

2 votes328 views1 answer
Insert from table tsql
SQL
0 vote387 views1 answer
Acutal month year
SQL
0 vote376 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
17 votes347 views6 answers
Get last record in sql
SQL
0 vote332 views2 answers
Php convert dbf to mysql
SQL
2 votes343 views2 answers
Change varchar length mysql
SQL
4 votes323 views2 answers
How to delete row in sql
SQL
0 vote324 views1 answer
Import mysql'
SQL
0 vote407 views1 answer
Get initial in sql
SQL
0 vote335 views1 answer
Ora 00001 error catch plsql
SQL