Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Use Group Functions in the SELECT Clause
How To Use Group Functions in the SELECT Clause? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY
✍: FYIcenter.com
If group functions are used in the SELECT clause, they will be used on the rows that meet the query selection criteria, the output of group functions will be returned as output of the query. The following select statement returns 3 values calculate by 3 group functions on all rows of the "fyi_links" table:
mysql> SELECT COUNT(*), MAX(counts), MIN(created) FROM fyi_links; +----------+-------------+---------------------+ | COUNT(*) | MAX(counts) | MIN(created) | +----------+-------------+---------------------+ | 7 | 8 | 2003-01-01 00:00:00 | +----------+-------------+---------------------+ 1 row in set (0.37 sec)
2007-05-11, 5025👍, 0💬
Popular Posts:
Jack developed a program by using a Map container to hold key/value pairs. He wanted to make a chang...
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer ...
Enable ASP.NET polling using “web.config” file Now that all our database side is configured in order...
How To Run "mysql" Commands from a Batch File? - MySQL FAQs - Command-Line End User Interface mysql ...
What Is a TD Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "td" elemen...