>IMHO, this is useless. I don't see how you can get twice the same record using a select SQL.
I didn't give a good explanation.
The TOP 10 will return more than 10 records if RAND() has selected the same value more than once.
This is why I always concatenate with my unique ID to make sure I will only have 10 records. I applied the same solution for the TOP 50 posters of a forum where the 50th position may be shared by more than one person.