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 


👟
Tiny Steps Weight Loss Coach
1:1 Daily WhatsApp Coaching • £30/month
Start Your Transformation Today £30 / month
✅ Personalised Plans
✅ Daily Check-ins
✅ No Burnout Method
✅ Cancel Anytime

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

Share







SubmitExpress.com