Difference between revisions of "SQL Error Messages"

From SQLZOO
Jump to: navigation, search
 
Line 48: Line 48:
 
<li>[[Ambigous column name |Error 7 ERROR: Column reference &quot;name&quot; is ambiguous]]</li>
 
<li>[[Ambigous column name |Error 7 ERROR: Column reference &quot;name&quot; is ambiguous]]</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 11:18, 19 July 2012

Error Messages

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

MySQL

SQL Server

Oracle

DB2

Postgres