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, 4803👍, 0💬
Popular Posts:
What Is the Data Pump Import Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump...
What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print ...
How do we host a WCF service in IIS? Note: - The best to know how to host a WCF in IIS is by doing a...
The object that contains all the properties and methods for every ASP.NET page, that is built is .. ...
Where are all .NET Collection classes located ? System.Collection namespace has all the collection c...