sslug-teknik team mailing list archive
-
sslug-teknik team
-
Mailing list archive
-
Message #81155
RE: SQL query
Doh! det skulle selvf være:
"SELECT MAX(a.tal) FROM ( SELECT tal, dato FROM tabel ORDER BY dato DESC LIMIT 10) a"
Søren
-----Original Message-----
From: soeren.koch@xxxxxxxx [mailto:soeren.koch@xxxxxxxx]
Sent: Wednesday, March 23, 2005 10:12 AM
To: sslug-teknik@xxxxxxxx
Subject: RE: [TEKNIK] SQL query
Ja noget i stil med "SELECT MAX(a.tal) FROM ( SELECT tal, date FROM tabel ORDER BY dato DESC LIMIT 10) a" burde gore det
Søren
Follow ups