Simple SELECT sigue ERROR

From: "Eduardo" <edukoski(at)montevideo(dot)com(dot)uy>
To: <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Simple SELECT sigue ERROR
Date: 2006-06-26 12:49:52
Message-ID: 000801c6991f$04efd420$d7680082@913040xp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

select AÑO, REGION, AGRICULTURA, V_AGRICULTURA, INDUSTR_CONSTR, V_INDUSTR_CONSTR, COMERCIO_SERVICIOS, NO_CORRESPONDE, V_NO_CORRESPONDE from ecotabpea WHERE AÑO =(SELECT MAX(AÑO) FROM ecotabpea)
El error es:

ERROR: You have an error in your SQL syntax to use near '(SELECT MAX(AÑO) FROM ecotabpea)' at line 1

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Sistemas C.M.P. 2006-06-26 13:44:57 posgreSQL con Joomla
Previous Message Blanca 2006-06-26 12:25:41 Duda sobre PgAdmin