Jump to content
Main menu
Main menu
move to sidebar
hide
SELECT basics
quiz
SELECT from world
quiz
SELECT from nobel
quiz
SELECT in SELECT
quiz
SUM and COUNT
quiz
JOIN
quiz
More JOIN
quiz
Using NULL
quiz
Self JOIN
quiz
Reference
NoSQL zoo
SELECT
Functions
SELECT .. WHERE
SELECT .. GROUP BY
SELECT .. JOIN
SELECT .. SELECT
INSERT .. VALUES
INSERT .. SELECT
UPDATE
DELETE
CREATE TABLE
CREATE VIEW
CREATE INDEX
DROP
ALTER
UNION
LEFT JOIN
NULL
SQLZoo
Search
Search
Log in
Personal tools
Log in
Contents
move to sidebar
hide
Beginning
1
Error Messages
Toggle Error Messages subsection
1.1
MySQL
1.2
SQL Server
1.3
Oracle
1.4
DB2
1.5
Postgres
Toggle the table of contents
Toggle the table of contents
SQL Error Messages
Page
Discussion
British English
Read
View source
View history
Tools
Tools
move to sidebar
hide
Actions
Read
View source
View history
General
What links here
Related changes
Special pages
Printable version
Permanent link
Page information
From SQLZoo
Error Messages
Error messages, how they are caused and what can be done about them.
MySQL
Error 1052 Column 'name' in field list is ambiguous
Error 1111 Invalid use of group function
Error 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error 1146 Table 'gisq.Bbc' doesn't exist
SQL Server
Msg 1013, Ambiguous column name 'name'.
Msg 147 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
Msg 208 Invalid object name 'noSuchTable'
IMsg 8120 Column 'xxx' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (SQL-42000)
Oracle
ORA-00918: column ambiguously defined
ORA-00934: group function is not allowed here
ORA-00937: not a single-group group function
ORA-00942: table or view does not exist
ORA-00979: not a GROUP BY expression
DB2
SQL0203N A reference to column "NAME" is ambiguous. SQLSTATE=42702
SQL0120N A WHERE clause, GROUP BY clause, SET clause, or SET transition-variable statement contains a column function.
SQL0204N "GISQ.NOSUCHTABLE" is an undefined name
SQL0119N An expression starting with "xxx" 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
Postgres
Error 7 ERROR: Column reference "name" is ambiguous
ERROR: Aggregates not allowed in WHERE clause
ERROR: Relation "nosuchtable" does not exist
Error 7 ERROR: Attribute xxx.xxx must be GROUPed or used in an aggregate function
DataWars:
Practice Data Science/Analysis with
+100 Real Life Projects
Your server today is: digitalocean-sqlzoo
Toggle limited content width