Questions tagged [distinct]

The DISTINCT keyword is used to remove duplicate values from a result of a SQL or SPARQL query.

The DISTINCT keyword is used to remove duplicate values from a result of a SQL or SPARQL query.

The SQL 92 Standard defines DISTINCT as:

Two values are said to be not distinct if either: both are the null value, or they compare equal... Otherwise they are distinct. Two rows (or partial rows) are distinct if at least one of their pairs of respective values is distinct. Otherwise they are not distinct.

The SPARQL 1.1 Specification describes DISTINCT as:

The DISTINCT solution modifier eliminates duplicate solutions. Only one solution that binds the same variables to the same RDF terms is returned from the query.

5114 questions

vote

2 answers

DAX: Distinct and then aggregate twice

I'm trying to create a Measure in Power BI using DAX that achieves the below. The data set has four columns, Name, Month, Country and Value. I have duplicates so first I need to dedupe across all four columns, then group by Month and sum up the…

asked Nov 21 '19 at 04:50

DJL

vote

1 answer

SQL count distinct with a condition based on a different column

I have a data set containing a list of exams, the qualifications/units they're associated with, and whether the exam was passed or failed. The data looks something like this: candidate | qualification | unit | exam |…

sql sql-server count distinct

asked Nov 20 '19 at 10:58

Sam Walpole

1,116
11
26

vote

2 answers

Remove duplicates from listbox/combobox in WPF

I've seen answers mentioning something compact like this:here List withDupes = LoadSomeData(); List noDupes = withDupes.Distinct().ToList(); So I tried the following (syntax) List withDupes =…

wpf combobox duplicates distinct listbox-control

asked May 04 '11 at 14:25

Marie

vote

1 answer

Count duplicate cell values as one if multiple criteria are met

I am trying to get the total count of entries per month based on the status ("Settled") and the distinct code. If the other status of the other entries in that certain code is not yet settled, it shouldn't count. Please see example below and the…

excel excel-formula distinct sumproduct

asked Nov 11 '19 at 07:19

Isabella

vote

1 answer

add values based on distinct values of another column from table with multiple records

I have a table like and i want to summaries like this So i want to sum packages for distinct items where my table could have multiple records that i can not just exclude cause are different. I can not just select sum(package) from table group…

mysql database sum distinct

asked Nov 08 '19 at 15:31

kyrpav

vote

2 answers

Running "distinct on" across all unique thresholds in a postgres table

I have a Postgres 11 table called sample_a that looks like this: time | cat | val ------+-----+----- 1 | 1 | 5 1 | 2 | 4 2 | 1 | 6 3 | 1 | 9 4 | 3 | 2 I would like to create a query that for each unique…

sql postgresql performance distinct distinct-on

asked Nov 07 '19 at 06:11

Coder

vote

2 answers

Count Distinct and Sum at different group levels in single Oracle query

Below is my query. Is there anyway to use different levels of group levels. I need to get product_count column to count distinct of Product_id but not at account_id and acct_type_id level. Currently the product_count column is coming as 1 for each…

sql oracle count grouping distinct

asked Nov 04 '19 at 14:24

Sara

vote

2 answers

Prevent duplicate values using group by and count distinct simultaneously?

I have a simple table with years and customer id and now I want to group by year and count distinct customers for each year. This is straightforward and works fine, my issue is that I don't want customers in year 1 to repeat in year 2, I only want…

sql-server database group-by count distinct

asked Oct 24 '19 at 22:32

learningtocode2k20

vote

1 answer

Cannot select distinct values on joins

Need to join different tables but during join to select distinct rows per one column I have the following…

sql sql-server left-join distinct

asked Oct 23 '19 at 06:38

Spiris

vote

2 answers

Selecting distinct values in MongoDB while using Studio 3T

I'd like to to select distinct values from my collection. My query right now, looks like this: use mongo; db.getCollection("Students").find( { "Name" : { "$exists" : true }, "Last_Name" : { …

mongodb select distinct

asked Oct 21 '19 at 12:36

Mason

vote

1 answer

Return multiple COUNT fields for distinct values per a unique ID based on two criteria conditions

I'm trying to work with some logging data in MySQL where I want to be able to tell, per individual, counts of the number of distinct successful requests, distinct unsuccessful requests, non-distinct successful requests, and non-distinct unsuccessful…

mysql sql count distinct where-clause

asked Oct 15 '19 at 19:41

lupinist

vote

1 answer

how do I only display each one of the data without repeating with a distinct laravel?

I have a query that takes id_user from several transactions. I just want to find the id_user in the user table by taking only 1 of each data. example: in the query there is a user id [1,1,3,4] i just want to take [1,3,4] so the name that comes out…

json laravel eloquent distinct laravel-5.8

asked Oct 15 '19 at 13:06

sindoro

vote

2 answers

DISTINCT AND COUNT(*)=1 not working on SQL

I need to show the ID (which is unique in every case) and the name, which is sometimes different. In my code I only want to show the names IF they are unique. I tried with both distinct and count(*)=1, nothing solves my problem. SELECT DISTINCT id,…

sql count duplicates distinct

asked Oct 14 '19 at 13:44

Ithil Maethor

vote

2 answers

MySQL distinct and left, right

I have a table with day column like this: 2011-04-28, 2011-04-29 ... day count name surname 2011-04-28 8 titi tutu 2011-04-28 12 tutu toto 2011-04-27 2 tutu toto 2011-03-12 10 tutu toto I can obtain…

mysql sql distinct

asked Apr 29 '11 at 17:05

scraly

vote

2 answers

List tree view using eloquent

php laravel eloquent tree distinct

asked Oct 10 '19 at 09:08

pal3

Prev 1 2 3

…

100