← Back to team overview

sslug-teknik team mailing list archive

Thread
Date

Re: SQL query

To: sslug-teknik@xxxxxxxx
From: Lars Riisgaard Ribe <lars@xxxxxxxxxxxxxxxx>
Date: Wed, 23 Mar 2005 19:38:01 +0100
Delivered-to: mailing list sslug-teknik@xxxxxxxx
In-reply-to: <2544D7C68F8A434D90AB26026992327AC05E2F@EXCHG-VS1.risoe.dk>
Mailing-list: contact sslug-teknik-help@xxxxxxxx; run by ezmlm
User-agent: Mozilla Thunderbird 1.0 (Windows/20041206)

"SELECT MAX(a.tal) FROM ( SELECT tal, dato FROM tabel ORDER BY dato DESC LIMIT 10) a"

Ja, bortset fra at det er en MySQL 4.0, der ikke understøttersubqueries.... Jeg kan desværre ikke selv komme i tanke om en fornuftigløsning.


/Lars

Follow ups

Re: SQL query
From: Martin Møller Pedersen, 2005-03-25
Re: SQL query
From: Hasse Hagen Johansen, 2005-03-23

References

RE: SQL query
From: soeren . koch, 2005-03-23