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 Divide Query Output into Groups
How To Divide Query Output into Groups? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY
✍: FYIcenter.com
You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in that column will be considered as a single group. When the GROUP BY clause is specified, the select statement can only be used to return group level information. The following script gives you a good GROUP BY example:
mysql> SELECT tag, COUNT(*), MIN(created), AVG(counts) FROM fyi_links GROUP BY tag; +------+----------+---------------------+-------------+ | tag | COUNT(*) | MIN(created) | AVG(counts) | +------+----------+---------------------+-------------+ | DBA | 3 | 2005-01-01 00:00:00 | 3.6667 | | DEV | 2 | 2004-01-01 00:00:00 | 4.0000 | | SQA | 2 | 2003-01-01 00:00:00 | 7.0000 | +------+----------+---------------------+-------------+ 3 rows in set (0.07 sec)
2007-05-11, 7577👍, 0💬
Popular Posts:
What Is C Language? The C programming language is a standardized programming language developed in t...
How To Set session.gc_divisor Properly? - PHP Script Tips - Understanding and Using Sessions As you ...
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, b...
Can you explain why your project needed XML? Remember XML was meant to exchange data between two ent...
What will be printed as the result of the operation below: main() { char *ptr = " Cisco Systems"; *p...