Not unique:

SELECT yourfield FROM yourtable GROUP BY yourtable.yourfield HAVING COUNT(*) > 1

>Dear Experts
>
>Field1 of Table1 has following data
>
>Boris
>Cetin
>Jeferson
>Cetin
>Tony
>Boris
>Validimir
>Boris
>
>Questin # 1
>I want to extract all unique matching records as
>Boris
>Cetin
>
>Questin # 2
>I want to extract not unique but all matching records as
>Boris
>Boris
>Boris
>Cetin
>Cetin
>
>Please Help