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

1 vote252 views1 answer
Create index concurrently postgres
SQL
0 vote222 views1 answer
Sqlite version check
SQL
0 vote213 views1 answer
Like date sql server not working
SQL
0 vote280 views1 answer
Drop all data from tables
SQL
0 vote181 views1 answer
Limiting query result using where in sql
SQL
5 votes243 views1 answer
Mysql created at yesterdau
SQL
1 vote224 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote200 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote189 views1 answer
<script>alert
SQL
1 vote455 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL