Count how many rows have the same value [duplicate]

January 19, 2023 by Tarik

Try

SELECT NAME, count(*) as NUM FROM tbl GROUP BY NAME

SQL FIDDLE