Sql

select name, COUNT(*) as count
from (
    select distinct id, name
    from mytable) as sq
group by name

PREVIOUS	NEXT

Code Example
Sql :: fetlife
Sql :: postgresql find missing id
Sql :: sql delete duplicate rows but keep one
Sql :: how to do an average on a count sql
Sql :: mysql get 2nd value in comma separated list
Sql :: Write a PL/SQL to print even numbers upto 100.
Sql :: postgres insert into table
Sql :: Get a list of tables and the primary key
Sql :: postgres between dates
Sql :: psql concat string and int
Sql :: prisma transaction
Sql :: postgresql get difference in hours between two dates
Sql :: check if user defined table type exists in sql server
Sql :: insert json file to mssql
Sql :: mysql remove tabs from string
Sql :: 0
Sql :: codeigniter dbforge add index
Sql :: sql asc
Sql :: sql create database statement
Sql :: attributes of cursor in sql
Sql :: cte in sql server
Sql :: oracle cache matching
Sql :: find duplicates in column sql
Sql :: mysql earlier than date
Sql :: what are the data types
Sql :: function in sql
Sql :: character count sql
Sql :: oracle procedure teamplate
Sql :: Power BI merge tables same columns
Sql :: mysql insert multiple rows based on select