Tham khảo tài liệu 'group functions', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 5 Group Functions ORACLG Objectives Identify the available group functions. Explain the use of group functions. Display statistics for different groups by using the GROUP BY clause. Include or exclude grouped rows by using the HAVING clause. 5-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives 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. Group Functions .
