SELECT
SysId,
`Port`,
a.Num-(SELECT Num FROM nowdata b ORDER BY b.CreatedTime desc limit 1)
FROM `nowdata` a limit 1;
SELECT Num FROM nowdata b ORDER BY b.CreatedTime desc limit 1;
SELECT
SysId,
`Port`,
Num
FROM `nowdata` a limit 1;
select Num from nowdata where to_days(now())-to_days(CreatedTime) <=1 ORDER BY CreatedTime desc limit 1;
select * from nowdata where to_days(now())-to_days(CreatedTime) <=1 ORDER BY CreatedTime limit 1;
SELECT
SysId,
`Port`,
a.Num-(select Num from nowdata b where to_days(now())-to_days(b.CreatedTime) <=1 ORDER BY b.CreatedTime desc limit 1)
FROM `nowdata` a where to_days(now())-to_days(a.CreatedTime) <=1 limit 1;
SysId,
`Port`,
a.Num-(SELECT Num FROM nowdata b ORDER BY b.CreatedTime desc limit 1)
FROM `nowdata` a limit 1;
SELECT Num FROM nowdata b ORDER BY b.CreatedTime desc limit 1;
SELECT
SysId,
`Port`,
Num
FROM `nowdata` a limit 1;
select Num from nowdata where to_days(now())-to_days(CreatedTime) <=1 ORDER BY CreatedTime desc limit 1;
select * from nowdata where to_days(now())-to_days(CreatedTime) <=1 ORDER BY CreatedTime limit 1;
SELECT
SysId,
`Port`,
a.Num-(select Num from nowdata b where to_days(now())-to_days(b.CreatedTime) <=1 ORDER BY b.CreatedTime desc limit 1)
FROM `nowdata` a where to_days(now())-to_days(a.CreatedTime) <=1 limit 1;