• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Groups

You can use the GROUP BY command to group the result of a query by one or more columns. In the following example, the total of the sold articles is specified for each article number:

SELECT ProductNr, SUM(Amount) AS TotalSales
		FROM tblProductSales
GROUP BY ProductNr


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint