汇总数据库中的详细信息 [英] Sum the details in data base

问题描述

我有一个名为Stock details的表，其中包含诸如
的列 日期/工厂1/工厂2/工厂3/总数/月总数/年总数.
{总计为factory1 + factory2 + factory3}
{month_total是从第一个月到该月的当前日期的库存详细信息}
{year_total是从1月1日到当前日期的库存详细信息}
所以这里的问题是我该如何编写查询来计算n年的月份总数
请帮忙！
谢谢☻☻☺☺☺

I''ve table called Stock details which has columns like
date/factory1/factory2/factory3/total/month_total/year_total.
{Total is factory1+factory2+factory3}
{month_total is stock details from the 1st month to the current date of that month}
{year_total is stock details from the 1st jan to the current date}
So the problem here is how do i write query to calculate year n month total
Please help!!
Thank you☻☻☺☺☺

推荐答案

select monthtotal+yeartotal_id as total from stockdetails

更新的解决方案:

updated solution:

select sum(total) as month_Total from stockdetails where day(date)<=day(Getdate()) and month(date)=month(getdate()) and year(Date)=year(getdate())

上面的查询将为我提供特定月份(从第一天到当前日期)的总计列的总和.

The above query will give me sum of total column for the particular month 1st to current date.

select sum(total) as year_total from stockdetails where day(date)<=day(Getdate()) and month(date)<=month(getdate()) and year(Date)=year(getdate())

如果您的表contians列具有月份总数和年份总数，则将为您提供总计年份

this will give you years total

.
那么您只能使用该值...

请尝试以下查询..

if your table contians column which having month total and year total.
then you can use that values only...

try below query..

select datepart(year,dt) yr, datepart(mm,dt) month, month_tot,year_tot 
from users 
where dt in (select max(dt) from Stock_details 
             group by datepart(year,dt),
                datepart(mm,dt))
order by 1 asc,2 asc,3 asc

这篇关于汇总数据库中的详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！