hi,
I think the following link would be some help for you!
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
Leo Huang
2006/2/14, Octavian Rasnita <[EMAIL PROTECTED]>:
>
> Hi,
>
> From: "Rhino" <[EMAIL PROTECTED]>
> ...
> > > I need to extract a list which the followin
om: "Octavian Rasnita" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>; "Rhino" <[EMAIL PROTECTED]>;
Sent: Monday, February 13, 2006 3:16 PM
Subject: Re: selecting min, max
PS, I have forgotten to tell that I am using MySQL 5.
Thank you.
PS, I have forgotten to tell that I am using MySQL 5.
Thank you.
Teddy
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Monday, February 13, 2006 10:00 PM
Subject: Re: selecting min, max
Hi,
From: "Rhino" <[EMAIL PROTECTED]>
...
> > I need to extract a list which the following values from this table, for
> > each hour (in date_time field):
> >
> > - symbol
> > - min(price)
> > - max(price)
> > - price where date_time is the earliest for that certain hour.
> > - price where the dat
Octavian,
I need to extract a list which the following values from this table, for
each hour (in date_time field):
- symbol
- min(price)
- max(price)
- price where date_time is the earliest for that certain hour.
- price where the date_time is the last from that hour.
- The sum of volume from
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To:
Sent: Monday, February 13, 2006 9:07 AM
Subject: selecting min, max
Hi,
I have a table with the following fields:
symbol, date_time, price, volume
I need to extract a list which the following values from this t
