You could also use
SELECT GroupID,
SomeValue
FROM tablename
ORDER BY MAX(CRYPT_GEN_RANDOM(4)) OVER (PARTITION BY GroupID),
SomeValue;
Martin Smith
- 86.5k
- 15
- 252
- 342