Author: Frédéric Date: To: guilde Subject: Re: Requète SQL
On dimanche 30 décembre 2012, Hugues Levasseur wrote:
> Select distinct t1.ts as allumage, t2.ts as extinction, timediff(t2.ts,
> t1.ts) as durée
> From test t1, test t2
> Where t1.ts in (SELECT ts FROM test WHERE object =
> 'heating_cmd_sdb_rdc' and value = 'on')
> and t2.ts = (SELECT ts FROM test WHERE object = 'heating_cmd_sdb_rdc'
> and value = 'off' and ts > T1.ts order by ts limit 1)
>
> Elle fonctionne avec deux restrictions :
> - Pour chaque "On" il faut le "Off" correspondant
> - Le timestamp doit être discriminant
