How To Simplify SQL Query For Get Faster Result

Transact-SQL
5

hi

i created the drop create data script
somebody please carry the torch

:slight_smile:
:slight_smile:

drop create data .. 
drop table #abc 
go 

create table #abc 
(
area varchar(3) ,
location varchar(10) ,
ip varchar(100),
humi varchar(10),
temp varchar(10),
door varchar(10),
N2 int ,
timerecord datetime 
)
go 

insert into #abc select 'T4','T4-Wave','10.128.174.38','51.3','25.6','Close',0,'2019-03-13 08:26:35:000'
insert into #abc select 'T4','T4-Wave','10.128.174.38','48.9','25','Close',0,'2019-03-13 08:34:35:000'
insert into #abc select 'T4','T4-Wave','10.128.174.38','51.3','25.6','Close',0,'2019-03-13 08:38:35.000'
insert into #abc select 'T4','T4-Wave','10.128.174.38','52','25.6','Close',0,'2019-03-13 08:39:35.000'
insert into #abc select 'T4','T4-Wave','10.128.174.38','51.2','25.6','Close',0,'2019-03-13 08:45:35.000'
insert into #abc select 'T4','T4-Wave','10.128.174.38','49.7','25.6','Close',0,'2019-03-13 08:29:35.000'

insert into #abc select 'T1','T1-Wave','10.208.174.47',58.6,22.2,'Close',0,'2019-03-13 08:43:34.000' 
insert into #abc select 'T1','T1-Wave','10.208.174.47',57.5,22.2,'Close',0,'2019-03-13 08:29:34.000'  
insert into #abc select 'T1','T1-Wave','10.208.174.47',53.8,21.5,'Close',0,'2019-03-13 08:39:34.000'  
insert into #abc select 'T1','T1-Wave','10.208.174.47',54.5,22.2,'Close',0,'2019-03-13 08:42:34.000'  
insert into #abc select 'T1','T1-Wave','10.208.174.47',56.1,22.2,'Close',0,'2019-03-13 08:26:34.000'  
insert into #abc select 'T1','T1-Wave','10.208.174.47',54.5,22.2,'Close',0,'2019-03-13 08:28:34.000'  
insert into #abc select 'T1','T1-Wave','10.208.174.47',55.4,21.7,'Close',0,'2019-03-13 08:36:34.000'  
insert into #abc select 'T1','T1-Wave','10.208.174.47',52.4,22.2,'Close',0,'2019-03-13 08:46:34.000'  
go 


select * from #abc 
go
2 Likes