Comparison of graphical tools for MySQL

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 13071
mysql tools

HTTP-tunnel - Ability to manage MySQL database via the Internet. More...

'mysql.proc' doesn't exist fixed problem


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