22,209
社区成员
发帖
与我相关
我的任务
分享
-- 建立初始数据
CREATE TABLE Person
(
PersonId INT IDENTITY(1,1) PRIMARY KEY,
PersonName NVARCHAR(50),
IdCard NVARCHAR(50),
PersonGender NCHAR(2),
Birthday DATETIME DEFAULT GETDATE()
)
INSERT INTO Person (PersonName,IdCard,PersonGender,Birthday) VALUES('a','123456789012345678',1,'1970-1-2')
INSERT INTO Person (PersonName,IdCard,PersonGender,Birthday) VALUES('a','123456789012345677',1,'1970-1-3')
INSERT INTO Person (PersonName,IdCard,PersonGender,Birthday) VALUES('a','123456789012345678',1,'1970-1-2')
INSERT INTO Person (PersonName,IdCard,PersonGender,Birthday) VALUES('b','123456789012345678',1,'1970-1-2')
INSERT INTO Person (PersonName,IdCard,PersonGender,Birthday) VALUES('b','123456789012345677',2,'1970-1-3')
INSERT INTO Person (PersonName,IdCard,PersonGender,Birthday) VALUES('c','123456789012345676',1,'1970-1-3')
select distinct p1.Personid,p1.PersonName,p1.idCard from Person as P1 , Person as p2
where p1.PersonName=p2.PersonName and p1.IdCard<>p2.idCard
create index xx_oo on person(personname,idcard,PersonId)