Top "Distinct" questions

Counting Using Group By Linq

I have an object that looks like this: Notice { string Name, string Address } In a List<Notice> I …

c# linq count group-by distinct

Retrieving last record in each group from database - SQL Server 2005/2008

I have done some seaching by can't seem to get the results I am looking for. Basically we have four …

sql-server-2005 tsql sql-server-2008 distinct

distinct in Xpath?

I have this XML file, from which I'd like to count the number of users referenced in it. But they …

xml xpath distinct

MySQL distinct count if conditions unique

I am trying to build a query that tells me how many distinct women and men there are in a …

mysql sql count distinct

Efficiently merge string arrays in .NET, keeping distinct values

I'm using .NET 3.5. I have two string arrays, which may share one or more values: string[] list1 = new string[] { "apple", "…

c# linq arrays merge distinct

How can I do a count distinct in sqlite?

I have a table: ref,type 1,red 2,red 3,green 4,blue 5,black 6,black I want the result of a sqlite query …

sqlite count sum distinct

SELECT UNION as DISTINCT

How do I perform a DISTINCT operation on a single column after a UNION is performed? T1 -- ID Value 1 1 2 2 3 3 …

mysql union distinct

Efficient way to select all values from one column not in another column

I need to return all values from colA that are not in colB from mytable. I am using: SELECT DISTINCT(…

sql performance distinct notin

One-To-Many relationship gets duplicate objects without using "distinct". Why?

I have 2 classes in a one-to-many relationship and a HQL query that is a bit strange. Even if I have …

java hibernate hql distinct one-to-many

Delete duplicate rows from a BigQuery table

I have a table with >1M rows of data and 20+ columns. Within my table (tableX) I have identified duplicate …

distinct google-bigquery