See How do I select duplicate records from a table? FAQ #7588 and Eliminating duplicates in a table FAQ #8129

>
>How can i exclude duplicate records from a table using select sql statements?
>
>I can't understand why my select distinct statement does not works. The result sets still includes duplicate records.
>
>Any other way to strip off duplicate records?
>
>TIA.