Re: SELECT MAX() problem
Posted by:
Lars Olzem
Date: September 12, 2012 09:45AM
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.
Subject
Views
Written By
Posted
2290
September 12, 2012 07:59AM
1285
September 12, 2012 08:50AM
985
September 12, 2012 09:39AM
959
September 19, 2012 04:12AM
Re: SELECT MAX() problem
1067
September 12, 2012 09:45AM
1446
September 12, 2012 12:09PM
1014
September 12, 2012 12:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.