in reply to OT: peak values with SQL

Use table aliases when using the same table in a correlated sub-query:
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

    Excellent, works like a charm. Many thanks.