Martijn Tonies wrote:

>> If there were 50 rows all with C_INT = 1
>> then your statement will return a random(ish)
>> selection of 10 of them.

> Hmm, good thinking... Not the correct solution as the OP
> did state that column "A" could have the same values...

I dont recall if he stated it or not... I assumed it to be
true because the secondary sort column would be redundant
without that condition - and the thread would be moot.

--
Geoff Worboys
Telesis Computing