SELECT AVG( zahl )
FROM
table
,
( SELECT @row:=0, @pct:=( @rows:=COUNT( zahl ) ) * 0.1 FROMtable
) r
WHERE
( @row:=@row + 1 )
BETWEEN
@pct AND ( @rows - @pct )
ORDER BY zahl ASC
Perfekt ;)
Danke!
MfG Naps
SELECT AVG( zahl )
FROM
table
,
( SELECT @row:=0, @pct:=( @rows:=COUNT( zahl ) ) * 0.1 FROMtable
) r
WHERE
( @row:=@row + 1 )
BETWEEN
@pct AND ( @rows - @pct )
ORDER BY zahl ASC
Perfekt ;)
Danke!
MfG Naps