select sum(列1)/60,sum(列2)/60 from 表 where 列三 between '2005-08-03 14:01:00.000' and '2005-08-03 15:00:00.000'
select sum(id)/60 id,sum(id1)/60 id1 from a where date1 between '2005-08-03 14:01:00.000' and '2005-08-03 15:00:00.000'是这样吗
select result=(col1+col2)/60 from tb_name where col3>='2005-08-03 14:01:00.000' and col3<='2005-08-03 15:00:00.000'--col1指第一列列名 --col2指第二列列名 --col3指第三列列名 --tb_name指表名
from 表
where 列三 between '2005-08-03 14:01:00.000' and '2005-08-03 15:00:00.000'
and '2005-08-03 15:00:00.000'是这样吗
--col2指第二列列名
--col3指第三列列名
--tb_name指表名