明明先生的专栏

原创 取重复数据的第一个条记录

  select  *  from [RemoteControlTryRecord]  a where id=(  select top 1 ID   from RemoteControlTryRecord  where a.MACID = MACID and ControResult=1   and ControlTime between '2018-04-08 00:00:00' and '2...

原创 服务器与客户间的通讯协议

原创 查询每天 所有设备试验成功了多少次，失败的SQl语句

  select count ( distinct macid)as Maccount , [ControlTime],sum (case when ControResult=1 then 1 else 0 end)   as SuccessCount,sum (case when ControResult=2 then 1 else 0 end) as  failCount from    ( ...