Difference between revisions of "SQL Error Messages"

From SQLZOO
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 39: Line 39:
 
</li>
 
</li>
 
</ul><ul>
 
</ul><ul>
<li><a href='err934/db2'>SQL0120N A WHERE clause, GROUP BY clause, SET clause, or SET transition-variable statement contains a column function.
+
<li>[[Invalid Group function |SQL0120N A WHERE clause, GROUP BY clause, SET clause, or SET transition-variable statement contains a column function.]]</li>
</a></li>
+
 
</ul><ul>
 
</ul><ul>
 
</ul><ul>
 
</ul><ul>
<li><a href='err942/db2'>SQL0204N &quot;GISQ.NOSUCHTABLE&quot; is an undefined name</a></li>
+
<li>[[Table doesn't exist |SQL0204N &quot;GISQ.NOSUCHTABLE&quot; is an undefined name]]</li>
 
</ul><ul>
 
</ul><ul>
<li><a href='err979/db2'>SQL0119N An expression starting with &quot;xxx&quot; specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified. SQLSTATE=42803</a></li>
+
<li>[[Incorrect GROUP BY |SQL0119N An expression starting with &quot;xxx&quot; specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified. SQLSTATE=42803]]</li>
 
</ul><h2>Postgres</h2><ul>
 
</ul><h2>Postgres</h2><ul>
<li><a href='err918/postgres'>
+
<li>[[Ambigous column name |Error 7 ERROR: Column reference &quot;name&quot; is ambiguous]]</li>
Error 7
+
ERROR: Column reference &quot;name&quot; is ambiguous
+
</a></li>
+
 
</ul><ul>
 
</ul><ul>
<li><a href='err934/postgres'>ERROR: Aggregates not allowed in WHERE clause</a></li>
+
<li>[[Invalid Group function |ERROR: Aggregates not allowed in WHERE clause]]</li>
 
</ul><ul>
 
</ul><ul>
 
</ul><ul>
 
</ul><ul>
<li><a href='err942/postgres'>ERROR: Relation &quot;nosuchtable&quot; does not exist</a></li>
+
<li>[[Table doesn't exist |ERROR: Relation &quot;nosuchtable&quot; does not exist]]</li>
 
</ul><ul>
 
</ul><ul>
<li><a href='err979/postgres'>Error 7
+
<li>[[Incorrect GROUP BY |Error 7 ERROR: Attribute xxx.xxx must be GROUPed or used in an aggregate function]]</li>
ERROR: Attribute xxx.xxx must be GROUPed or used in an aggregate function</a></li>
+
 
</ul>
 
</ul>

Latest revision as of 12:18, 19 July 2012

Contents

Error Messages

Error messages, how they are caused and what can be done about them.

MySQL

SQL Server

Oracle

DB2

Postgres

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense