Previous Topic: -79 - UPDATE/DELETE WHERE CURRENT OF cursorname ON READ ONLY CURSORNext Topic: -82 - EACH QUERY IN A UNION MUST HAVE THE SAME NBR OF PROJECTED COLUMNS

SQL Codes › SQL Return Codes -1 through -999 › -80 - ONLY ONE DISTINCT CLAUSE ALLOWED PER QUERY

-80 - ONLY ONE DISTINCT CLAUSE ALLOWED PER QUERY

Reason:

The key word DISTINCT appears more than once in the clause or statement indicated. This is a violation of the SQL grammar.

The SQLSTATE that equates to this SQL return code is 42905.

Action:

Eliminate multiple occurrences of the DISTINCT keyword so that it appears only once in the query.