Top "Distinct" questions

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

Select distinct values from 1 column

I want to select distinct values from only one column (the BoekingPlaatsId column) with this query: SELECT MAX(BoekingPlaatsId), BewonerId, …

sql sql-server sql-server-2005 distinct
Select distinct values from multiple columns in same table

I am trying to construct a single SQL statement that returns unique, non-null values from multiple columns all located in …

sql distinct union
How does Distinct() function work in Spark?

I'm a newbie to Apache Spark and was learning basic functionalities. Had a small doubt.Suppose I have an RDD …

apache-spark distinct
Efficient latest record query with Postgresql

I need to do a big query, but I only want the latest records. For a single entry I would …

sql postgresql subquery distinct
Efficient Count Distinct with Apache Spark

100 million customers click 100 billion times on the pages of a few web sites (let's say 100 websites). And the click stream …

distinct apache-spark
Get distinct values of Queryset by field

I've got this model: class Visit(models.Model): timestamp = models.DateTimeField(editable=False) ip_address = models.IPAddressField(editable=False) If …

django field distinct django-queryset
PG::Error: SELECT DISTINCT, ORDER BY expressions must appear in select list

ActionView::Template::Error (PG::Error: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list I'm creating an …

ruby-on-rails ruby ruby-on-rails-3 postgresql distinct
Find distinct values, not distinct counts in elasticsearch

Elasticsearch documentation suggests* that their piece of code *documentation fixed GET /cars/transactions/_search?search_type=count { "aggs": { "distinct_colors": { "…

elasticsearch distinct
How to implement IEqualityComparer to return distinct values?

I have a L2E query that returns some data that contains duplicate objects. I need to remove those duplicate …

c# entity-framework distinct iequalitycomparer
MYSQL UNION DISTINCT

I have two selects that I'm currently running as a UNION successfully. (SELECT a.user_id, a.updatecontents AS city, …

mysql left-join union distinct