select max(mob) as maxmob,min(mob) as minmob from table group by convert(varchar(50),gpstime,23)
我这样一个查询出来的却是 maxmob 9.9 minmob 0.2但是其实我select mob from table出来的mob都是400多的值 怎么会这样?
我这样一个查询出来的却是 maxmob 9.9 minmob 0.2但是其实我select mob from table出来的mob都是400多的值 怎么会这样?
select max(mob) as maxmob,min(mob) as minmob from table 试试,
另外,mob的数据类型及给一些实际数据的示例看看
最大是9.9,最小是0 但我直接搜索 mob的话数据是有很多的啊 好几百的都有 最大绝对不是9.9
数据是 select max(mob) as maxmob,min(mob) as minmob from table搜索出的数据是 max是9.9 min是0
min(cast(mob as decimal(38,2))) as minmob
from table group by convert(varchar(50),gpstime,23)
select convert(varchar(10),gpstime,120) as gpstime,
max(cast(mob as decimal(38,6))) as maxmob,
min(cast(mob as decimal(38,6))) as minmob
from table
where isnumeric(mob) = 1
group by convert(varchar(10),gpstime,120)
max(cast(mob as decimal(38,6))) as maxmob,
min(cast(mob as decimal(38,6))) as minmob
from table
where isnumeric(mob) = 1
group by convert(varchar(10),gpstime,120)
order by max(cast(mob as decimal(38,6))) desc