Re: Problem with select
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
Subject
Written By
Posted
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.