前几天遇到一个难题，对两个数据表中的数据进行数据统计，要求：同年，同月，同人，同车的数据自动进行统计，并通过OWC将对应的信息进行
USE
TQNPOA
GO
/**/
/*成功语句*/
select
Cdriver
as
司机,Ctype
as
车型,Cnumber
as
车号,
sum
(cfutel)
as
月耗油量,
datename
(
year
, Stimte)
as
年,
datename
(
month
, stimte)
as
月
from
ViewDriverUOil
group
by
datename
(
year
, Stimte),
datename
(
month
, stimte),Ctype,Cdriver,
Cnumber
order
by
datename
(
year
, stimte)
asc
select
Ctype
as
车型,Cmonth
as
月份,COiluse
as
耗油量
from
Car_oil_info
USE
TQNPOA
GO
/**/
/*成功语句*/
select
Cdriver
as
司机,Ctype
as
车型,Cnumber
as
车号,
sum
(cfutel)
as
月耗油量,
datename
(
year
, Stimte)
as
年,
datename
(
month
, stimte)
as
月
from
ViewDriverUOil
group
by
datename
(
year
, Stimte),
datename
(
month
, stimte),Ctype,Cdriver,Cnumber
order
by
datename
(
year
, stimte)
asc
select
Ctype
as
车型,Cmonth
as
月份,COiluse
as
耗油量
from
Car_oil_info
扫一扫
1194
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
