Difference between revisions of "SQL Error Messages"

From SQLZOO
Jump to: navigation, search
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><a href='err934/postgres'>ERROR: Aggregates not allowed in WHERE clause</a></li>

Revision as of 11:16, 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

  • <a href='err934/postgres'>ERROR: Aggregates not allowed in WHERE clause</a>
  • <a href='err942/postgres'>ERROR: Relation "nosuchtable" does not exist</a>
  • <a href='err979/postgres'>Error 7 ERROR: Attribute xxx.xxx must be GROUPed or used in an aggregate function</a>
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense