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, 4690👍, 0💬
Popular Posts:
What is the difference between Session State and ViewState? ViewState is specific to a page in a ses...
Wha is the output from System.out.println("Hell o"+null);?Hellonull
How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configu...
What is AL.EXE and RESGEN.EXE? In the previous question you have seen how we can use resource files ...
How do we assign page specific attributes ? Page attributes are specified using the @Page directive.