group funtions

Chia sẻ: Ba Toan | Ngày: | Loại File: PDF | Số trang:38

lượt xem

group funtions

Mô tả tài liệu
  Download Vui lòng tải xuống để xem tài liệu đầy đủ

This lesson further addresses functions. You will focus on obtaining summary information, such as averages, for groups of rows. You will discuss how to group rows in a table into smaller sets, and how to specify search criteria for groups of rows. At the end of this lesson, you should be able to  Identify the available group functions.  Explain the use of group functions.  Use the GROUP BY clause to force statistics to be displayed for different groups.  Use the HAVING clause to include or exclude grouped rows....

Chủ đề:

Nội dung Text: group funtions

Đồng bộ tài khoản