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
Trending right now
Some things I am selling please have a look What is the difference between Jam and peanut butter Joke on how i met your mother The Hidden Question That Tricks Your Brain Into Attracting Massive Wealth Effortlessly The Hidden Question That Tricks Your Brain Into Attracting Massive Wealth Effortlessly Contrails or chemtrails Single duvet featuring caticorn ie cat like a uncorn white and pink Can you download your ebay listings into an excel spreadsheet How to send a postal cheque to lloyds bank plc Simple easy way to get out of jury service with no hassle. What have we learnt about humanity since covid appeared. Council Tax attachment of earnings removal letter How to return only part of a feild from database using php substr but to take into account spaces The Unpermitted Power of a Free Mind How to remove item specifics on ebay Excellent Snacks to have on the carnivore diet Are cows really responsible for global warming Are you a commercial electrical company How Niching Down Your Product Can Skyrocket Your Profits To get a free starter from pizza express simply enter this code Disney frozen bath towel very good condition How to count how many records of a field are in a database
|