select code,max (MaxValue_Real) max_dut,max(MaxValue_Tar) max_bak,o.ObjectGarNum,m.MarkCarName from bn.dbo.FLEET_AnalogTarirovka as T
inner join bn.dbo.SYS_DEV_Sensor as s on s.id=t.idsensor
inner join bn.dbo.SYS_DEV_Device as d on d.id=s.device_id
left JOIN bn.dbo.FLEET_Object as O on o.device_id=d.id and objectactive=1
left join bn.dbo.FLEET_MarkCar as M on m.MarkCarID=o.MarkCarID
where d.deviceactive=1 and s.sensoractive=1
group by code ,o.ObjectGarNum,m.MarkCarName --having max (MaxValue_Real) not in (4096,1024)
order by max (MaxValue_Real) desc