ansaurus

Question

Counting Instances of Unique Value in Field

Answer 1

+4 A:

How about:

SELECT Prices, COUNT(*) FROM TheTable GROUP BY Prices

Can't say I've tried it on MySql, but I'd expect it to work...

Jon Skeet 2009-10-22 08:56:18

Thank you very much indeed. I wasn't selecting it! Instead I was doing something like: SELECT * FROM TheTable COUNT(Prices). Cheers!

day_trader 2009-10-22 09:01:05

`SELECT Prices, COUNT(*) as C FROM TheTable GROUP BY Prices ORDER BY C` in case you want to sort by count. :)

o.k.w 2009-10-22 09:03:19

Thank you :). Just out of curiosity as well, let's say we have a 'TheTableTWO' and there's a column in there called 'Genre' which links to these price. How would I display that as well? therefore example output would be "13.99 || 65425 || Horror".

day_trader 2009-10-22 09:08:24

Why don't you elaborate further on this question or ask a fresh new one and link to that from here? Reason being your original question is already has an accepted answer and it's kinda hard to answer via comment.

o.k.w 2009-10-22 09:16:53

Nice, here's the linked question: http://stackoverflow.com/questions/1606062/count-instances-in-table1-and-link-to-table2

o.k.w 2009-10-22 09:41:04

ansaurus

tags:

views:

answers:

Counting Instances of Unique Value in Field

related questions