grouping 2007-11-03 - By Brent Baisley
Back
It sounds to me like you might be trying to find the standard
deviation or the variance, which are functions you can use right in
your query.
On Nov 2, 2007, at 7:37 AM, Octavian Rasnita wrote:
> Hi,
>
> I have a table with the following columns:
>
> symbol
> date
> value
>
> I want to select all the symbols (grouping by symbols) between 2
> specified dates, and calculate the percent of change for each symbol.
>
> The percent of change is (the value from the last date of the
> symbol - the value from the first date) / the value from the first
> date.
>
> For example I have:
>
> SMB1, 2007-01-01, 1000
> SMB1, 2007-03-15, 2100
> SMB1, 2007-10-10, 1300
> ... (other symbols)
>
> And the result of the select should be:
> SMB1, 0.3
>
> Is it possible to do this with an MySQL query?
>
> Thank you.
>
> Octavian
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=brenttech@(protected)
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
