Matt Warden wrote: > So, for something like this: > > id name > 1 bob > 1 matt > 2 jane > 3 mary > > select distinct id, name from table; > > what does it do for id 1? I just ran some more tests, and I guess I stand corrected. I don't know what happened yesterday.