select EmployeeID, Name from FamilyMember
group by EmployeeID,Name
having count(1)>1
group by EmployeeID,Name
having count(1)>1
解决方案 »
- 请问这样的表单如何做sql查询
- 请问存储过程可不可以定时运行?
- SQL 计算问题!
- 进来看看,急救!!!!在线等
- 初学者的sql查询的连接问题,请帮忙!
- 求sq语句
- 有一单机版程序用sql sql7.0作为数据库,我想把程序和sql sql7.0一起打包做安装盘,不知道用installshield把sql sql7.0打包需要那些文件
- 各位大侠,请问在sql server2000中执行"SELECT * INTO [;DATABASE=c:\db2.mdb].BK_T1 FROM T1"语句会出错?
- SQL 进程问题!急!!!!!!!!!!!!!!!!
- 求查询
- dts数据库复制问题
- 请问各位版主:XP系统下如何安装SQL SERVER
select EmployeeID,Name from FamilyMember
group by EmployeeID,Name
having count(*)>1
select First.ID, First.EmployeeID, First.Name
from FamilyMember First, FamilyMember Second
where First.EmployeeID=Second.EmployeeID
and First.Name=Second.Name
and First.ID<>Second.ID