Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to group those datas ?
Great ! That's exactly what I want ! Thank you very much ! -
how to group those datas ?
First, thanks a lot for your response... (No problem with "DATE", I have given this name for the example but the real name is different.) This solution is interesting but it doesn't correspond exactly to my problem. But I have forgottent something in my example. Here is the correct example ... -
how to group those datas ?
Here is a sample of my database : DATE | OPERATOR ---------------------- 2004-08-01 | ope1 2004-08-01 | ope3 2004-08-03 | ope2 2004-08-03 | ope1 2004-08-03 | ope3 2004-08-07 | ope2 2004-08-10 | ope3 ("Operator" is an enum of 'ope1', 'ope2', 'ope3') And I want to obtain something like... -
column value count
Hello everybody ! I don't know how to count different values from a column. I axplain myself : Here is my DB : (PLACE & PEOPLE are strings, GAME is a SET of (game1, game2, game3) PLACE PEOPLE GAME Tokyo Mr A game1 Tokyo Mr B game1 N-Y Mr C game2 Paris Mr D...
