how to count how many records of a field are in a database

how to count how many records of a field are in a database

how to count how many records of a column are in your database and sort by the count

Use the select query below will produce a count on each variation in the field you require.

Simply change the fieldname to be your fieldname in the database and the tablename to the the name of the table

SELECT fieldname , COUNT( * ) AS counta FROM tablename GROUP BY fieldname ORDER BY counta DESC

HOW TO GET MORE CUSTOMERS

How to stop paying council tax 

I'm having a clear out, new things added daily

How to stop paying council tax

Stunning cushion 40cm x 40cm...

Stunning cushion 40cm x 40cm Constellations of thoughts


£24.00

Matt Handcock Pin cushion...

Matt Handcock Pin cushion


£3.99

Wine bottle gift bag/ holder...

Wine bottle gift bag/ holder linen new hand made


£3.00

Bean Bag door stop - new ...

Bean Bag door stop - new


£4.00

New Glasses Holder...

New Glasses Holder


£4.00

New Glasses Holder...

New Glasses Holder


£4.00

Stunning cushion 40cm x 40cm...

Stunning cushion 40cm x 40cm Constellations of thoughts


£24.00

Cleaner in Woking