MySQL Forums
Forum List  »  Newbie

Re: Problem with select
Posted by: Felix Geerinckx
Date: May 03, 2005 11:42AM

Christian Merkel wrote:

> i have a table witch colects traffic data.
>
> Struckture of table:
>
> Hour | Amount | Lane
> 10 | 23 | 1
> 10 | 29 | 2
>
> The struckture of the output should be like this
>
> Hour | Lane1 | Lane2
> 10 | 23 | 29
>

This is a crosstab query. Read my response to a similar question from a few days ago here:
http://forums.mysql.com/read.php?20,23727,23732#msg-23732

--
felix

Options: ReplyQuote


Subject
Written By
Posted
May 03, 2005 10:30AM
Re: Problem with select
May 03, 2005 11:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.