Ci provo ...
HTHcodice:SELECT (SELECT COUNT(campo) FROM tabella WHERE time<x) AS a, (SELECT COUNT(campo) FROM tabella WHERE time>x AND time<y) AS b, (SELECT COUNT(campo) FROM tabella WHERE time>y) AS c
Zappa
Ci provo ...
HTHcodice:SELECT (SELECT COUNT(campo) FROM tabella WHERE time<x) AS a, (SELECT COUNT(campo) FROM tabella WHERE time>x AND time<y) AS b, (SELECT COUNT(campo) FROM tabella WHERE time>y) AS c
Zappa
[PC:Presario 2515EU][Cpu:P4@2.3GHz][Ram: 512M][HDU:80G@5400 RPM]
[Wireless:LinkSys][OS: Ubuntu 9.04 - Jaunty Jackalope]