sql Óï¾ä¸ß·ÖÇó½â

create table test1
(
eqpid  varchar(10),
stauts varchar(20),
duration int,
changedate datetime
)

insert into test1 select 'sb01','running','60','2010-01-31 1:00:00';

insert into test1 select 'sb01','idle','60','2010-01-31 2:00:00';

insert into test1 select 'sb01','alarm','120','2010-01-31 4:00:00';

insert into test1 select 'sb01','running','180','2010-01-31 7:00:00';

insert into test1 select 'sb02','running','121','2010-01-31 2:01:00';

insert into test1 select 'sb02','idle','181','2010-01-31 5:02:00';

insert into test1 select 'sb02','alarm','61','2010-01-31 6:03:00';

insert into test1 select 'sb02','running','62','2010-01-31 7:05:00';

/*
Ï£ÍûµÃµ½Èçϵı¨±í£¬ÁÐÊǶ¯Ì¬Éú³ÉµÄ£¬Òª¸ù¾Ý״̬³öÏֵĴÎÊý¶¯Ì¬Éú³É

eqpid  running11 idle11 alarm11 running12 running21 idle21 alarm21 running22
sb01  60        60      120    180      0          0    0          0
sb02  0