Fredrick Bartlett [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 01, 2004 10:12 PM
> To: Schulman, Michael; [EMAIL PROTECTED]
> Subject: Re: Time series
>
>
> Is Hour a DateTime? If so, will this work...
>
> SELECT ticker, DATE_FORMAT(Hour,'%H' ), min(pric
od, though
I've only used it on a 100,000 row table. It can get a little hairy writing
the queries though.
Chris
-Original Message-
From: Schulman, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 7:14 PM
To: 'Fredrick Bartlett'; [EMAIL PROTECTED]
Subject: RE:
on 1/1/04 9:59 PM, Schulman, Michael wrote:
> That only returns one number.. what we are really looking for is something
> like
>
> SELECT ticker, hour, first(price), last(price) from pricedata group by hour
Well, if you're using MySQL 4.1+, you're in luck. A subquery should help.
SELECT ticker
>> First: select * from table1 order by field1 asc limit 1
>> Last: select * from table1 order by field1 desc limit 1
> That only returns one number.. what we are really looking for is something
And worse: as far as I can tell 3.22.x even if field1 is indexed, ONE
of those queries is going to be
Hi Mike,
I'm working in a large Data Capture Division of Lason Inc. in India, I
have developed a
Database which is used to report Server Load & Server space utilization
online, I'm designing this layout
with some what critical process.
It's not in millian rows per day, but in thousands... al
ve is
trying to do.
Thanks again,
Mike
-Original Message-
From: Fredrick Bartlett [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 10:12 PM
To: Schulman, Michael; [EMAIL PROTECTED]
Subject: Re: Time series
Is Hour a DateTime? If so, will this work...
SELECT ticker, DATE_F
;[EMAIL PROTECTED]>
To: "'Fredrick Bartlett'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, January 01, 2004 6:59 PM
Subject: RE: Time series
> That only returns one number.. what we are really looking for is something
> like
>
> SELECT ticker
: Thursday, January 01, 2004 9:57 PM
To: Schulman, Michael; [EMAIL PROTECTED]
Subject: Re: Time series
Hmmm...
First: select * from table1 order by field1 asc limit 1
Last: select * from table1 order by field1 desc limit 1
- Original Message -
From: "Schulman, Michael" <[EMAIL P
Hmmm...
First: select * from table1 order by field1 asc limit 1
Last: select * from table1 order by field1 desc limit 1
- Original Message -
From: "Schulman, Michael" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 01, 2004 6:47 PM
Subject: Time series
> Hi,
>
> I w