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:
Can Group Functions Be Mixed with Non-group Selection Fields
Can Group Functions Be Mixed with Non-group Selection Fields? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. The script below gives you an example of invalid SELECT statements with group and non-gorup selection fields:
SQL> SELECT COUNT(*), department_id FROM departments; ORA-00937: not a single-group group function
In this example, COUNT(*) is a group field and department_id is a non-group field.
2007-04-20, 4678👍, 0💬
Popular Posts:
What Is C Language? The C programming language is a standardized programming language developed in t...
How To Create Nested Tables? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells You can cr...
How can you check to see whether a symbol is defined? You can use the #ifdef and #ifndef preprocesso...
What does XmlValidatingReader class do? XmlTextReader class does not validate the contents of an XML...
What Tools to Use to View HTML Documents? The basic tool you need to view HTML documents is any Web ...