Hey,
Thanks a lot! I didn't see this response until now.
I did not try it as I went with the column based solution. However
this looks like it will work.
I will implement and let you know.
Thanks again,
On 1/23/09, Peter Brawley wrote:
> Attila,
>
>>I would like to select only the most recen
Attila,
I would like to select only the most recent "targettime" within 1 minute and
only display only the rows that are "the latest" and print out all of the
stats as columns on a per toolname basis:
One way: a three-step:
1. There is a formula (see "Group data by time periods" at
http://ww
At 02:19 PM 1/22/2009, Weston, Craig (OFT) wrote:
From: Attila [mailto:attee...@gmail.com]
Sent: Thursday, January 22, 2009 3:06 PM
To: mysql@lists.mysql.com
Subject: Need to pivot rows into columns
...
I am using MySQL and have found some possibilities with SQL Server (Pivot,
crosstab, etc) ...
From: Attila [mailto:attee...@gmail.com]
Sent: Thursday, January 22, 2009 3:06 PM
To: mysql@lists.mysql.com
Subject: Need to pivot rows into columns
...
I am using MySQL and have found some possibilities with SQL Server (Pivot,
crosstab, etc) ... but the requirements call for MySQL.
Is the above q
