MySQL Tools Comparison.

  • Increase font size
  • Default font size
  • Decrease font size
Home Aggregate Functions and Grouping
Aggregate Functions and Grouping
In this lesson of the MySQL tutorial, you will learn...
  1. How to GROUP data elements.
  2. How to aggregate values to generate summary results.
  3. How to filter on grouped results using HAVING.
  4. How to use ROLLUP to generate summary rows.
  5. How to find TOP-n and BOTTOM-n entities.

The SELECT statement is used to retrieve data from tables. SELECT statements can be used to perform simple tasks such as retrieving records from a single table or complicated tasks such as retrieving data from multiple tables with record grouping and sorting. In this lesson, we will look at several of the more basic ways to retrieve data from a single table.

Title Filter     Display # 
# Article Title Hits
1 Aggregate Functions and Grouping 13781





I used HTTPtunnel GNU package for the organization HTTP tunnel with HeidiSQL. Read more...

'mysql.proc' doesn't exist fixed problem


Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...