Random Record Within Group

[warrenk]

I know I can get a random record using:

select top 1 * from yourtable order by rnd(id)

What I need to do is pick a random record within a group:

Example:



I would like to pick 3 random records (one in each group). How can I do this?

ID	Group
1	A
2	A
3	A
4	B
5	B
6	B
7	C
8	C
9	C

[June7]

Bing: Access query random records each group

Does this help
https://www.accessforums.net/program...rds-31396.html
http://www.access-programmers.co.uk/...d.php?t=155152

[Dal Jeanis]

Try something like this -

  SELECT T0.MyGroup, T1.MyID
  FROM MyTable AS T0,
       (SELECT TOP 1
        T1.MyID, T1.NewRandom(MyID)
        FROM MyTable
        WHERE T0.MyGroup = T1.MyGroup
        ORDER BY NewRandom(MyID));

NewRandom is posted here - https://www.accessforums.net/queries...der-38336.html
It goes in a standard module.