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 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