MySQL Forums :: Newbie :: Noob query issue


Advanced Search

Noob query issue
Posted by: nicolas jean ()
Date: January 05, 2011 06:46AM

Hi everyone,

I'm sorry to ask this question but i'm working on my query for 6 hours and i can't figure how to solve it...

Here is the table

2009;STATUS1;1
2009;STATUS1;2
2009;STATUS1;3
2009;STATUS2;6
2009;STATUS3;5
2009;STATUS2;9
2010;STATUS1;11
2010;STATUS1;12
2010;STATUS2;13
And i would like to have a report like that in one query.

2009 Count occurence of status 1
2009 Count occurence of status 2
2009 Count occurence of status 3
2010 Count occurence of status 1
2010 Count occurence of status 2
2010 Count occurence of status 3

Is it possible ??

Thanks a lot



Edited 2 time(s). Last edit at 01/05/2011 07:21AM by nicolas jean.

Options: ReplyQuote


Subject Written By Posted
Noob query issue nicolas jean 01/05/2011 06:46AM
Re: Noob query issue laptop alias 01/05/2011 07:04AM
Re: Noob query issue nicolas jean 01/05/2011 07:24AM
Re: Noob query issue laptop alias 01/05/2011 07:30AM
Re: Noob query issue nicolas jean 01/05/2011 08:01AM
Re: Noob query issue laptop alias 01/05/2011 08:19AM
Re: Noob query issue nicolas jean 01/05/2011 08:26AM
Re: Noob query issue laptop alias 01/05/2011 09:11AM
Re: Noob query issue nicolas jean 01/05/2011 10:41AM
Re: Noob query issue Rick James 01/05/2011 09:41AM
Re: Noob query issue nicolas jean 01/05/2011 10:40AM


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.