sql GROUP通过选择 [英] sql GROUP By selection

问题描述

我想通过选择使用Group选择数据，



i尝试编写一个查询。错误

I want to Select a data using Group by selection,

i try to write a query.it' wrong

SELECT * FROM  tblInboundHeader INNER JOIN tblViaDetails ON tblInboundHeader.viaCode = tblViaDetails.viaCode WHERE  (manifestDate>='2013/10/01' AND manifestDate<='2013/10/10') AND hubCode='HKG'  GROUP BY tblViaDetails.mawb 

 SELECT * FROM  tblInboundHeader INNER JOIN tblViaDetails ON tblInboundHeader.viaCode = tblViaDetails.viaCode WHERE  (manifestDate>='2013/10/01' AND manifestDate<='2013/10/10') AND hubCode='HKG'  GROUP BY tblInboundHeader.viaCode

plase任何人都可以帮助我。谢谢。





这是我的桌子。

plase any one can help me. Thank You.


This is my tables.

SELECT [inboundSeqNo],[viaCode],[hawbCode],[manifestDate],[issueDate]
      ,[pkgModeCode],[shipperCode],[shipperName] ,[shipperAddress1],[shipperAddress2]
      ,[shipperDistrict],[shipperCountryCode],[consigneeCode],[consigneeName]
      ,[consigneeAddress1],[consigneeAddress2],[consigneeCountryCode],[contactPerson]
      ,[consigneeCityCode],[consigneeTelNo],[consigneeFax],[consigneeEmail]
      ,[contactPerson],[noOfPieces],[grossWeight],[chargebleWeight],[pkgTypeCode],[pkgContent]
      ,[customsValue],[billTo],[CODAmount],[value],[deliveryRate],[agentRemarks],[isConfirmed]
      ,[confirmedItems],[agentCode],[rateCode],[curType],[trackNumber],[ThirdPartyAccount] l,   [compCode]
FROM [TEST_DB].[dbo].[tblInboundHeader]

SELECT [hubCode],[mawb] ,[flNum],[flDate]  ,[flTime],[genDate],[deliveryDate],[remarks],[viaUsed],[accountRef],[viaFlag],[viaCode],[IntanalRemark] ,[ConfToInvoice] ,[ConfUserID] ,[ConfDateTime]FROM [TEST_DB].[dbo].[tblViaDetails]

推荐答案

你想要分组，所以你必须在select语句中指定一个聚合子句，而不是<$ c我们经常看到$ c> SELECT * ，因为这是一个很糟糕的习惯。



你不得不怀疑的问题是：它是什么是因为你想分组？ （例如：字段总数，平均值等）

You want to group by, so you have to specify an aggregation clause in your select statement, instead of SELECT * that we see too often because it is a terrible habit.

The question you have to wonder is : what it is as a result that you want to group by? (eg: a sum of fields, an average, etc.)

这篇关于sql GROUP通过选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！