Home » Performance » MySQL » counting in my sql XxY
counting in my sql XxY [message #3057] Fri, 09 May 2008 05:36 Go to previous message
delta2cain1  is currently offline delta2cain1
Messages: 7
Registered: May 2008
Junior Member
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.

Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:Large table
Next Topic:Create merge table using unpriviledge user
Goto Forum:

  



Current Time: Wed Aug 27 20:53:04 EDT 2008

Total time taken to generate the page: 0.01226 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge