← Back to team overview

sslug-teknik team mailing list archive

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