一条SQL语句的写法

[chenqun]

在不知表里客户同名的姓名时如何用slect语句查询出来表中同名的姓名。谢谢！！！

[chenqun]

急！急！急！

[Delphi_Li]

Select Name, Count( * ) X From YourTable
Where ( X > 1 )
Group By Name

[chl_ccssddnn]

应该感谢楼上的

[IORILI]

Select Name, Count( * ) X From YourTable
Where ( X > 1 )
Group By Name

[江山易改]

select * from Table
group by Name having count(Name)>1

[sysirm]

Select Name, Count( * ) X
From YourTable
Where ( X > 1 )
Group By Name