|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
February 25th, 2003, 02:41 AM
|
|||
|
|||
|
is horizontal aggregation present in mysql?
is horizontal aggregation available in mysql?
i mean Microsoft Access has the feature pivot table and cross tab query, which allows user to collect values in a row? Is it available in Mysql? IF AVAILABLE how could it be done? or Is there a source code for it? pls help....
|
|
#2
February 26th, 2003, 12:52 AM
|
|||
|
|||
|
RE: is horizontal aggregation present in mysql?
can you please elaborate what exactly is 'horisontal aggregation'?
i don't use access (like most of us here), and i am not a native english speaker, so, if you can give some example, maybe i (we) can help you...
|
|
#3
February 26th, 2003, 06:52 AM
|
|||
|
|||
|
RE: is horizontal aggregation present in mysql?
TOOLS YEAR No_Purch BUYER
hammer 2002 1 randen hammer 2001 1 paolo screwdriver 2000 1 dianne pliers 2003 2 angelo hammer 2002 2 neil hammer 2003 3 iris pliers 2004 3 iris screwdriver 2001 2 iris pliers 2000 4 dianne GIVEN THESE VALUES: how can i make an output which LOOKS like this? TOOLS 2000 2001 2002 SUM(No_Purch) pliers 4 0 0 4 hammer 0 1 3 4 screwdriver 1 2 0 3 HOW COULD THIS be DONE in mysql?
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > is horizontal aggregation present in mysql? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
