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

0 vote360 views1 answer
Set a value by excuting stored procedure
SQL
0 vote366 views1 answer
Sqlite explain plan
SQL
0 vote347 views2 answers
Plsql function that return a table
SQL
0 vote367 views1 answer
Mysql DDL
SQL
0 vote398 views1 answer
Pl/pgsql declare variable
SQL
0 vote373 views1 answer
Close sql query vb.net
SQL
11 votes349 views2 answers
Set default column value sql
SQL
9 votes342 views2 answers
Mysql change value
SQL
0 vote355 views4 answers
Change schema in sql server
SQL
14 votes342 views2 answers
How to auto increment in sql
SQL