>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

select distinct FirstName from Table1

* or:

select FirstName from Table1;
  group by FirstName

>Questin # 2
>I want to extract not unique but all matching records as
>Boris
>Boris
>Boris
>Cetin
>Cetin

select FirstName from Table1;
  order by FirstName

Is this what you need? I hope I understood your question correctly.