???????????????????????????????????????????????￡?

CREATE TABLE [dbo].[WUSU_SUOLITest_Table](
 [ID] [bigint] IDENTITY(1??1) NOT NULL??
 [ReceiveTime] [datetime] NULL??
 [GroupID] [bigint] NOT NULL??
 [DataValue] [float] NULL??
 [SensorCode] [char](10) NOT NULL??
)


???????????????????????????????????????????????????????豸??????id?е???ReceiveTime???????

?????????????SensorCode??????????豸??????50???豸???30?????????????ReceiveTime??????????????????????????????豸????ε??????

???????????????μ??????

select * from  WUSU_SUOLITest_Table where id in (select max(id) from  WUSU_SUOLITest_Table group by SensorCode )


???????????????С??????????????????????????????????????????????????14???к?????????????id???о????????SensorCode?????????????????ж?????á??????????????group by???

???????????????????????????????????????????????????β???????????μ??????????????????????????????????50??????????????????

create TRIGGER [dbo].[UpdateWUSU_LastOriginalDataSUOLI]
   ON  [dbo].[WUSU_SUOLITest_Table]
   AFTER  INSERT
AS
BEGIN
    declare @SensorCode char(10)?? @DataValue float ??@ReceiveTime datetime ??@GroupID bigint
   
    select @SensorCode=SensorCode??@DataValue=DataValue??@ReceiveTime=ReceiveTime??@GroupID=GroupID from inserted
      update WUSU_LastOriginalData set DataValue=@DataValue??ReceiveTime=@ReceiveTime??GroupID=@GroupID
          where SensorCode=@SensorCode
END


?????????????????????豸?μ?????????????????μ???????????????100????????????????????????????????????????

????????????и??????????????????????￡????????????

??????????????ù?????????????????group by???????????????????????????????????????????20????

select * from WUSU_SUOLITest_Table as t
where id  = (select max(id) from WUSU_SUOLITest_Table where SensorCode=t.SensorCode )