Re: SELECT MAX() problem

[Lars Olzem]

SELECT
ip,
port,
MAX(timestamp) AS timestamp,
MAX(type) AS type,
MAX(values) AS values
FROM
serverlist
GROUP BY
ip,
port

funktioniert leider nicht. Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS values FROM serverlist GROUP BY ' at line 6

sobald ich MAX(values) AS values weglasse, geht es wieder
type = varchar(100)
values = varchar(10000)



Edited 1 time(s). Last edit at 09/12/2012 09:59AM by Lars Olzem.