2 D query

delta2cain1 · Joined: 09 May 2008 Posts: 2

Hi I have a table with 2 columns Name (variable type) and CODE (variable type)

I need to retrieve a result in the following format

NAME -->
CODE
| FREQUENCY
|
V

The number of names may vary
so also the code

I Need to write a query in MySQL

Please point me in the right direction.

allaboutgeo · Joined: 09 May 2008 Posts: 11

I am unable to understand your requirement.
_________________
Geosciences

delta2cain1 · Joined: 09 May 2008 Posts: 2

SELECT ABC , count(*) AS "Count", XYZ FROM profile WHERE XYZ IN (SELECT DISTINCT a.XYZ FROM profile a) GROUP BY ABC,XYZ;

gives me a table of type

ABC COUNT XYZ
a 23 z
b 45 z
c 65 z
...

a 76 y
b 56 y
...
...

a 45 x
b 46 x

etc etc

now i neet it to be put in the format

XYZ z y x .....
ABC
a 23 76 45 ...
b 45 56 46 ...
c 65 ......
. . . .
. . . .

Help Me plz

i have 3000000 + records how can i optimize the query