例子1.

create table profession

(
    id int not null identity primary key,
    profession varchar(20)
)

insert into  profession (profession)

 select profession from my_contacts group by profession order by profession