Tut,

You'll have to test for yourself, but I'm pretty sure that a

select Field1, count(*) as cnt ... group by 1

is going to be the fastest way.

>I want to know what's the fastest way to comparing the records in a table returning amount of the unique records...