PMFJI,
Mohammed,
I think because you are doing this in SQL server the syntax is slightly different (SQL is less flexible with the ordering of some commands).
First things first,
Try and get the second select working on it's own
select distinct au_lname from authors having count(*)>1 group by au_lname
I think you need to put the having AFTER the group by eg.
select distinct au_lname from authors group by au_lname having count(*)>1
>Cetin
>
>Hello it does not worked
>
>select * from au_lanme where au_lname in
> (select distinct au_lname from authors having count(*)>1 group by au_lname)
>
>
>The Error Is
>
>Server: Msg 156, Level 15, State 1, Line 2
>Incorrect syntax near the keyword 'group'.
>
>
>Thanks
>Mohammed
Will Jones