Hi Rodolfo Random ≠ unique. If you really need a tie breaker, you'll have to sort on the uiqueKey field.
What is your use case here? When using a cursor, sorting on a random field will yield confusing results. Thomas Op ma 30 aug. 2021 om 17:33 schreef rgamarra <rgama...@gmail.com>: > Hi there! I'm using random fields (eg sort=random_1234 DESC) as a tie > breaker. > > I'm wondering the underlying random sequence how many digits uses for each > generated number. > > My result sets my contain (in principle) millions of results, so I would > like to have an estimation of possible clashes (ie two results ending with > the same random under, and then being a tie in the result set). > > Best regards. > > -- > Rodolfo Federico Gamarra >
