•Re: OT: peak values with SQL

Seems like you're going at it the hard way. Why not just:

SELECT uptime_id AS uid, uptime_value
FROM uptime
WHERE uptime_value = (SELECT MAX(uptime_value) FROM uptime);
[download]

Comment on •Re: OT: peak values with SQL Download Code

Replies are listed 'Best First'.
Re: •Re: OT: peak values with SQL by jZed (Prior) on Jun 05, 2004 at 17:00 UTC
Because your query returns only a single peak value, rather than a list of all peak values as the OP requested.	[reply]
•Re^2: •Re: OT: peak values with SQL by merlyn (Sage) on Jun 05, 2004 at 22:36 UTC
I suppose there's a difference between "all the peak values" and "all the values that are peak" that isn't discernable within a half hour of waking. Sorry. {grin} -- Randal L. Schwartz, Perl hacker Be sure to read my standard disclaimer if this is a reply.	[reply]