logo
  • About us
  • Services
  • Products
  • Work
  • Contact

Feedback

In Focus

  • Flash XML slideshow
  • Database training

2.1.27. Aggregates over sub-bags

  • Can run over subsets of tuples
  • GROUP BY keyword
  • Specifies the grouping attributes
  • Need to also appear in projected attr_list
  • Show result along side value for group attr
  • e.g. AggFunc over subgroups
    • SELECT dno, COUNT(*)
    • FROM employee
    • GROUP BY dno

Quick SQL check, do all attributes in the SELECT projection list appear in the GROUP BY projection list.

‹ 2.1.26. Aggregate functionsup2.1.28. Creating views ›
  • s5 slideshow
 

 

 

Copyright 2007 Lightenna Limited

  • About us
  • Services
  • Products
  • Work
  • Contact