0

Question might be confusing but this is what I want to achieve:

Item1 | Item2 | Item3
------+-------+------
3     | 5     | 11

What I've tried is this:

SELECT 
    [Items], COUNT([Number of Items]) AS Counts
FROM 
    [table] 
GROUP BY 
    [Items]

but this was the result:

Items | Counts
------+-------
Item1 | 3
Item2 | 5
Item3 | 11

How can I get those results above (the first one)?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459

0 Answers0