/SQL/Sql count how many times a value appears

Sql count how many times a value appears

* For Example
- You have a table called t1 & in that table you want to know how many times "ABC" name occured.
So your query will be.

select name, count(*) as total FROM t1 GROUP BY name

Source: grepper.com

Similar codes

0 vote113 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote121 views1 answer
Oracle change password expiration policy
SQL
6 votes112 views1 answer
Identify primary key in oracle table
SQL
0 vote108 views1 answer
Database traccar
SQL
0 vote100 views1 answer
Get all employees if name ends with in sql
SQL
1 vote109 views2 answers
Mysql update table from another table
SQL
0 vote103 views1 answer
Date datatype in livesql
SQL
0 vote110 views1 answer
Create table database in psql
SQL
0 vote121 views1 answer
Mariadb change column type
SQL
0 vote114 views1 answer
Compress sql file database ubuntu
SQL