SQLÁ½¸ö±íͳ¼Æ

SQL code:

---²âÊÔÊý¾Ý---
if object_id('[grxs]') is not null drop table [grxs]
go
create table [grxs]([tc_name] varchar(2),[tc_sex] int,[sj] datetime)
insert [grxs]
select 'ÕÅ',-1 ,'2010-2-4' union all
select 'ÕÅ',-3 ,'2010-2-4' union all
select 'Íõ',-2 ,'2010-2-4' union all
select 'Àî',-1 ,'2010-2-7' union all
select '³Â','0','2010-2-7' union all
select 'ÕÔ',-2 ,'2010-2-10'
if object_id('[jbb]') is not null drop table [jbb]
go
create table [jbb]([bjcr] varchar(2),[pc_class] char(1),[bmmc] varchar(5),[lrsjtj] datetime)
insert [jbb]
select 'ÕÅ','A','³µÕ¾','2010-2-14' union all
select 'Íõ','A','°à×é','2010-2-16' union all
select 'Íõ','B','³µÕ¾','2010-2-17' union all
select '³Â','B','°à×é','2010-2-17' union all
select '»Æ','A','³µÕ¾','2010-2-17' union all
select 'ÕÔ','B','°à×é','2010-2-17' union all
select 'ÕÔ','B','°à×é','2010-2-20'


ÎÒÏë²éÁ½¸ö±í2010-2-3µ½2010-2-28Ö®¼äµÄÊý¾Ý£º

tc_name  tc_sexµÃ·Ö AÀà  A³µÕ¾·Ö BÀà  B³µÕ¾·Ö  A°à×é·Ö  B°à×é·Ö ºÏ¼ÆµÃ·Ö ʵµÃ½ð¶î 
ÕÅ          -4      1    -6.6  0      0        0        0      89.4    268.2
Íõ          -2      1      0  &nbs