SyntaxFix

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

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

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to count

• Count the Number of Tables in a SQL Server Database • SQL count rows in a table • How to count the occurrence of certain item in an ndarray? • Laravel Eloquent - distinct() and count() not working properly together • How to count items in JSON data • Powershell: count members of a AD group • How to count how many values per level in a given factor? • Count number of rows by group using dplyr • C++ - how to find the length of an integer • JPA COUNT with composite primary key query not working

Examples related to distinct

• Using DISTINCT along with GROUP BY in SQL Server • How to "select distinct" across multiple data frame columns in pandas? • Laravel Eloquent - distinct() and count() not working properly together • SQL - select distinct only on one column • SQL: Group by minimum value in one field while selecting distinct rows • Count distinct value pairs in multiple columns in SQL • sql query distinct with Row_Number • Eliminating duplicate values based on only one column of the table • MongoDB distinct aggregation • Pandas count(distinct) equivalent