On Fri, Aug 12, 2005 at 18:57:34 +0100,
Nick Stone <[EMAIL PROTECTED]> wrote:
> Hope this helps
>
> SELECT
> *
> FROM
> speed_history as outside etc..
> WHERE
> (speed = (
> SELECT
> speed
> FROM
> speed_hi
Nick Stone wrote:
> Hope this helps
>
> SELECT
> *
> FROM
> speed_history as outside etc..
> WHERE
> (speed = (
> SELECT
> speed
> FROM
> speed_history as inside etc..
> WHERE
>
> Data in speed history looks like this:
> interface_id updated_time speed
> 1 2005-08-11 08:10:23 450112
> 1 2005-08-11 10:53:34 501120 <---
> 1 2005-08-11 10:58:11 450112
> 2 2005-08-11 08:10:23 450112 <---
>
D]
On Behalf Of Lane Van Ingen
Sent: 12 August 2005 16:09
To: pgsql-sql@postgresql.org
Subject: [SQL] SQL Newbie
It seems to me that I should be able to do this, but after 5 hrs of trying,
I can't figure this one out.
I could do this in two queries, but seems like I should be able to do this
in
On 8/12/05 11:09 AM, "Lane Van Ingen" <[EMAIL PROTECTED]> wrote:
> It seems to me that I should be able to do this, but after 5 hrs of trying,
> I
> can't figure this one out.
>
> I could do this in two queries, but seems like I should be able to do this
> in
> one. What I am trying to do:
> Find
It seems to me that I should be able to do this, but after 5 hrs of trying,
I
can't figure this one out.
I could do this in two queries, but seems like I should be able to do this
in
one. What I am trying to do:
Find the highest speed at which each interface of a router has run over
time.
I have
