> This is good to know, I have never known the answer to this. > If you code the returned query as if there was only one row, do you know > which one it would be? Would it be the last one it found, or the first one, > or a random one? I would guess it would return the first one it finds. Technically AFAIK it is the first one it finds, i.e. at random. In practice, result sets are *generally* returned in the order the records were inserted into the table. This is my experience anyhow.