Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Use Group Functions in the SELECT Clause
How To Use Group Functions in the SELECT Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: 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 4 values calculate by 4 group functions on all rows of the "departments" table:
SQL> SELECT COUNT(*), MIN(department_id), 2 MAX(department_id) FROM departments; COUNT(*) MIN(DEPARTMENT_ID) MAX(DEPARTMENT_ID) ---------- ------------------ ------------------ 27 10 270
2007-04-20, 4642👍, 0💬
Popular Posts:
What is the difference between strings and character arrays? A major difference is: string will have...
What is cross page posting? By default, button controls in ASP.NET pages post back to the same page ...
How To Delete All Rows a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statement...
What is a delegate ? Delegate is a class that can hold a reference to a method or a function. Delega...
How Is the Width a Parent Element Related to Child Elements? - CSS Tutorials - Understanding Multipl...