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 vote264 views1 answer
How to get number of months between 2 dates sql server
SQL
21 votes263 views6 answers
Update sql
SQL
0 vote180 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote242 views3 answers
Call to undefined function mysql_connect()
SQL
1 vote198 views1 answer
Postgres delete from where date is greater than specific date
SQL
1 vote289 views1 answer
Column with prefix in sql
SQL
0 vote195 views2 answers
Mysql multiply
SQL
16 votes187 views3 answers
Delete row psql
SQL
0 vote200 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote250 views1 answer
Ora 00001 error catch plsql
SQL