Top "Distinct" questions

Selecting distinct 2 columns combination in mysql

I have a mysql table that looks like this: 1 value1 value2 3534 2 value1 value1 8456 3 value1 value2 3566 4 value1 value3 7345 5 value2 value3 6734 I …

mysql sql database distinct distinct-values

Getting a distinct value across 2 union sql server tables

I'm trying to get all distinct values across 2 tables using a union. The idea is to get a count of …

sql union distinct distinct-values

SQL Performance: SELECT DISTINCT versus GROUP BY

I have been trying to improve query times for an existing Oracle database-driven application that has been running a little …

sql performance oracle group-by distinct

Spark: How to translate count(distinct(value)) in Dataframe API's

I'm trying to compare different ways to aggregate my data. This is my input data with 2 elements (page,visitor): (PAG1,…

count apache-spark distinct dataframe apache-spark-sql

Criteria.DISTINCT_ROOT_ENTITY vs Projections.distinct

I am pretty new to Hibernate. I found out that we can get distinct result using following two different ways. …

hibernate nhibernate distinct hibernate-criteria

How to make a "distinct" join with MySQL

I have two MySQL tables (product and price history) that I would like to join: Product table: Id = int Name = …

mysql join distinct left-join subquery

Linq Distinct() by name for populate a dropdown list with name and value

I'm trying to populate a Drop down list with pharmaceutical companies, like Bayer, Medley etc. And, I'm getting theses names …

c# linq-to-sql distinct

Select distinct column along with some other columns in MySQL

I can't seem to find a suitable solution for the following (probably an age old) problem so hoping someone can …

mysql select distinct

SQL distinct and count

I have a query where I want to get distinct dates, the phone numbers associated with those dates, and a …

sql count aggregate distinct

linq distinct or group by multiple properties

How can I using c# and Linq to get a result from the next list: var pr = new List<…

c# linq group-by distinct