in reply to OT: peak values with SQL
SELECT u1.uptime_id as uid, u1.uptime_value FROM uptime u1 WHERE u1.uptime_value > (SELECT u2.uptime_value FROM uptime u2 WHERE u2.uptime_id = u1.uptime_id+1);
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: OT: peak values with SQL
by revdiablo (Prior) on Jun 05, 2004 at 00:18 UTC |