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 vote135 views2 answers
Temp Space
SQL
0 vote129 views1 answer
Write sql query to show the details start from digit
SQL
1 vote126 views3 answers
Getdate function in postgresql
SQL
10 votes121 views1 answer
Dba_dependencies
SQL
0 vote140 views1 answer
Is not sql
SQL
16 votes136 views1 answer
CTE statement sql server
SQL
1 vote176 views1 answer
Concat first name and last name in mysql
SQL
-1 vote126 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote120 views1 answer
How to search query in python3 sqlite3
SQL
1 vote129 views1 answer
Sql delete all values in a column
SQL