A simple SELECT needed

Hi Gurus!
I have a table with 2 cols colA and colB.

The data is as follows:

colA colB
john smith
smith john

I wish to select only one of these rows, or I wish to even delete one of these rows.
How would I do it?

Thanks!

In the future, please limit your questions to one forum. You answer is already waiting at http://www.dbasupport.com/forums/sho...threadid=17876