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...