Count distinct value pairs in multiple columns in SQL

Question

What query will count the number of rows  but distinct by three parameters   Example   Id      Name        Address                                 1     MyName        MyAddress 2     MySecondName  Address2   Something like   select count distinct id name address  from mytable

User · Answer

Get all distinct id  name and address columns and count the resulting rows   SELECT COUNT    FROM mytable GROUP BY id  name  address

User · Answer

You can also do something like   SELECT COUNT DISTINCT id   name   address  FROM mytable

User · Answer

Having to return the count of a unique Bill of Materials  BOM  where each BOM have multiple positions  I dd something like this  select t item  t pono  count distinct ltrim rtrim t item     cast t pono as varchar 3    as  BOM Pono Count  from BOMMaster where t pono   1 group by t item  t pono  Given t pono is a smallint datatype and t item is a varchar 16  datatype

User · Answer

Another  probably not production-ready or recommended  method I just came up with is to concat the values to a string and count this string distinctively   SELECT count DISTINCT concat id  name  address   FROM mytable

User · Answer

To get a count of the number of unique combinations of id  name and address   SELECT Count    FROM             SELECT DISTINCT                id                name                address         FROM   your table          As distinctified

[sql] Count distinct value pairs in multiple columns in SQL

Examples related to sql

Examples related to count

Examples related to distinct