sql random sampling per group

Solutions on MaxInterview for sql random sampling per group by the best coders in the world

showing results for - "sql random sampling per group"

1with randomly_sorted_users as (
2
3    select
4        user_id,
5        signup_date,
6        row_number() over(partition by date_trunc('year', signup_date)
7                            order by random()) as random_sort
8    from
9        user_table
10
11)
12select
13    user_id,
14    signup_date
15from
16    randomly_sorted_users
17where
18    random_sort <= 5

similar questions

sql avg and group by t sql random number for each row mysql select row with max value group by select random rows sql sql random integer group by 15 minute interval sql server stratified sampling sql generate random 26 unique mysql string how to generate a unique random number in mysql sql select max value for each group sql select most frequent value in group select random sample sql min max sql group by sql select random procentage from rows sql pick random row sql avg group by sql query row number group by

queries leading to this page

sql random sampling per group sql random sampling per group