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

3 votes138 views1 answer
Start mysql server linux terminal
SQL
0 vote169 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote111 views1 answer
Update set with join pl sql
SQL
10 votes141 views2 answers
Linux command line import mysql database
SQL
0 vote149 views5 answers
Linq cheat sheet
SQL
0 vote174 views1 answer
Oracle winter time change
SQL
0 vote155 views1 answer
Where date major today mysql
SQL
0 vote186 views1 answer
ORACLE PARSE STRING
SQL
24 votes175 views4 answers
Delete db postgres
SQL
2 votes148 views1 answer
Possgress drop if exists table
SQL