<div>
select productname, <br />
sum (case when Size = 'S' then 1 else 0 end) SizeS<br />
sum (case when Size = 'M' then 1 else 0 end) SizeM<br />
sum (case when Size = 'L' then 1 else 0 end) SizeL<br />
from &lt;Table&gt;<br />
group by productName
</div>


select productname,
sum (case when Size = 'S' then 1 else 0 end) SizeS
sum (case when Size = 'M' then 1 else 0 end) SizeM
sum (case when Size = 'L' then 1 else 0 end) SizeL
from <Table>
group by productName

<div>
you might want to use pivot query<br />
<br />
try something like this:<br />
<br />
SELECT * FROM (SELECT Title,Code,'Size'+Size as sz FROM Table_1) Data<br />
PIVOT (COUNT(Code)<br />
FOR sz IN([SizeS],[sizeM],[SizeL]<wbr />)) AS CountSize
</div>


you might want to use pivot query

try something like this:

SELECT * FROM (SELECT Title,Code,'Size'+Size as sz FROM Table_1) Data
PIVOT (COUNT(Code)
FOR sz IN([SizeS],[sizeM],[SizeL])) AS CountSize

<div>
ged325, you are missing some commas
</div>


<div>
<div class="content wysiwyg-content">
HI<br />
<br />
I have a query that gives me the following information:<br />
<br />
Code, ProductName, Size<br />
&nbsp; 1 &nbsp; &nbsp; &nbsp; Blouse &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S<br />
&nbsp; 2 &nbsp; &nbsp; &nbsp; Blouse &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S<br />
&nbsp; 3 &nbsp; &nbsp; &nbsp; Skirt &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M<br />
&nbsp; 4 &nbsp; &nbsp; &nbsp; Pants &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;L<br />
<br />
The idea is to reorganize the information like this:<br />
<br />
ProductName, SizeS, SizeM, SizeL<br />
&nbsp;Blouse &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; 0<br />
&nbsp;Skirt &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; 0<br />
&nbsp;Pants &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
<br />
Any ideas?<br />
<br />
Regards.
</div>
</div>


HI

I have a query that gives me the following information:

Code, ProductName, Size
  1       Blouse              S
  2       Blouse              S
  3       Skirt                  M
  4       Pants                L

The idea is to reorganize the information like this:

ProductName, SizeS, SizeM, SizeL
 Blouse               2         0         0
 Skirt                   0         1         0
 Pants                 0         0         1

Any ideas?

Regards.

How to reorganize an sql query?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.