久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

對聯(lián)合查詢求和

Sum a union query(對聯(lián)合查詢求和)
本文介紹了對聯(lián)合查詢求和的處理方法,對大家解決問題具有一定的參考價值,需要的朋友們下面隨著小編來一起學習吧!

問題描述

限時送ChatGPT賬號..

我使用的是 Microsoft SQL Svr Mgmt Studio 2008.我無權創(chuàng)建臨時表(公司限制創(chuàng)建或修改表的能力),或者我會用它來解決這個問題.

I'm using Microsoft SQL Svr Mgmt Studio 2008. I don't have access to create a temporary table (company restricts ability to create or modify tables) or I would use that to solve this problem.

我已經(jīng)成功地使用聯(lián)合查詢來組合三個選擇查詢的結果.現(xiàn)在我試圖總結聯(lián)合的結果.

I have successfully used a union query to combine the results of three select queries. Now I am trying to sum the results of the union.

當我執(zhí)行下面的查詢時,我收到:

When I execute the query below I receive:

Incorrect syntax near the keyword 'GROUP'

然后當我通過我刪除組時:

And then when I remove the group by I get:

Incorrect syntax near ')'

這是我目前的查詢:

Select Period, PCC, SUM(BasicHits), SUM(FareHits), SUM(SearchHits)
From (

SELECT     AAAPeriod AS Period, 
AAAFromPCC AS PCC, 
- SUM(AAABasic) AS BasicHits,
- SUM(AAAFare) AS FareHits,
- SUM(AAASearch) AS SearchHits
FROM        HitsAaa
HAVING     (AAAPeriod = N'2010-10') 

UNION ALL

SELECT     AAAPeriod, 
AAAtoPCC,
SUM(AAABasic),
SUM(AAAFare),
SUM(AAASearch) 
FROM        HitsAaa
HAVING     (AAAPeriod = N'2010-10')

UNION ALL

SELECT      AgtPeriod, 
AgtPcc, 
SUM(AgtBasic),
SUM(AgtFare),
SUM(AgtSearch)
FROM          HitsAgent
HAVING      (AgtPeriod = N'2010-10')

)GROUP BY Period, PCC

對于之前的任何問題,我都無法找到解決方案.

I haven't been able to find a solution to this on any of the previous questions.

推薦答案

你需要給你的派生表取別名,你還必須使用一個帶有 have 子句的 group by.

You need to alias your derived table, you must also use a group by with a having clause.

SELECT
  q1.Period, 
  q1.PCC, 
  SUM(q1.BasicHits), 
  SUM(q1.FareHits), 
  SUM(q1.SearchHits)
FROM (SELECT     
        AAAPeriod AS Period, 
        AAAFromPCC AS PCC, 
        - SUM(AAABasic) AS BasicHits,
        - SUM(AAAFare) AS FareHits,
        - SUM(AAASearch) AS SearchHits
      FROM HitsAaa
      GROUP BY 
        AAAPeriod, 
        AAAFromPCC
      HAVING (AAAPeriod = N'2010-10') 

      UNION ALL

      SELECT     
        AAAPeriod AS Period, 
        AAAtoPCC AS PCC,
        SUM(AAABasic) AS BasicHits,
        SUM(AAAFare) AS FareHits,
        SUM(AAASearch) AS SearchHits 
      FROM HitsAaa
      GROUP BY 
        AAAPeriod, 
        AAAtoPCC
      HAVING (AAAPeriod = N'2010-10')

      UNION ALL

      SELECT
        AgtPeriod AS Period, 
        AgtPcc AS PCC, 
        SUM(AgtBasic) AS BasicHits,
        SUM(AgtFare) AS FareHits,
        SUM(AgtSearch)  AS SearchHits
      FROM HitsAgent
      GROUP BY 
        AgtPeriod, 
        AgtPCC
      HAVING (AgtPeriod = N'2010-10')) q1 
GROUP BY 
  q1.Period, 
  q1.PCC

這篇關于對聯(lián)合查詢求和的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網(wǎng)!

【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題,如果有圖片或者內(nèi)容侵犯了您的權益,請聯(lián)系我們刪除處理,感謝您的支持!

相關文檔推薦

What SQL Server Datatype Should I Use To Store A Byte[](我應該使用什么 SQL Server 數(shù)據(jù)類型來存儲字節(jié) [])
Interpreting type codes in sys.objects in SQL Server(解釋 SQL Server 中 sys.objects 中的類型代碼)
Typeorm Does not return all data(Typeorm 不返回所有數(shù)據(jù))
Typeorm .loadRelationCountAndMap returns zeros(Typeorm .loadRelationCountAndMap 返回零)
How to convert #39;2016-07-01 01:12:22 PM#39; to #39;2016-07-01 13:12:22#39; hour format?(如何將“2016-07-01 01:12:22 PM轉(zhuǎn)換為“2016-07-01 13:12:22小時格式?)
MS SQL: Should ISDATE() Return quot;1quot; when Cannot Cast as Date?(MS SQL:ISDATE() 是否應該返回“1?什么時候不能投射為日期?)
主站蜘蛛池模板: 中文字幕视频在线观看免费 | 夜夜爽99久久国产综合精品女不卡 | 日本精品一区二区三区在线观看视频 | 成人黄色电影免费 | 亚洲人在线播放 | 欧美精品一区二区三区在线 | 精品国产乱码久久久久久88av | 国产高清一区二区三区 | 成人性生交大片 | 国产精品久久久久久久久久 | 天天躁日日躁狠狠躁2018小说 | 一区二区三区国产精品 | 中文字幕日韩欧美一区二区三区 | 国产精品久久久久久久久动漫 | 美女二区| www.五月婷婷.com| 日本黄色影片在线观看 | 在线看日韩 | 男人久久天堂 | 99久久久无码国产精品 | 日韩欧美国产成人一区二区 | 三级特黄特色视频 | 澳门永久av免费网站 | 亚洲欧美一区二区三区1000 | 久久精品久久久 | 日韩精品一区二区三区在线播放 | 久久久夜夜夜 | 久久99国产精品久久99果冻传媒 | 在线免费观看a级片 | 国产精品一二三区 | 国产高清在线精品 | 精品一二三区在线观看 | 久久天天躁狠狠躁夜夜躁2014 | 国产97久久| 国产精品一区二区欧美黑人喷潮水 | 夜久久| 91国产视频在线观看 | 国产精品美女久久久久久久网站 | 日韩一级| 国产成人精品久久 | 美女国产 |