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