Top "Distinct" questions

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

Oracle Query: Get distinct names having count greater than a threshold

I have a table having schema given below EmpID,MachineID,Timestamp 1, A,01-Nov-13 2, A,02-Nov-13 3, C,03-Nov-13 1, B,02-Nov-13 1, C,04…

oracle count group-by distinct having-clause
C# MongoDB Distinct Query Syntax

I am trying to get the distinct values from a field in MongoDB. I am having real trouble with the …

c# mongodb distinct distinct-values
How to fetch distinct values with arel/relational algebra

I'm doing my best to bend my brain around arel and the relational algebra behind it, but how to represent …

distinct relational-algebra arel
What's better for creating distinct data structures: HashSet or Linq's Distinct()?

I'm wondering whether I can get a consensus on which method is the better approach to creating a distinct set …

linq performance distinct hashset
Select distinct values in all nested collections using LINQ to objects?

Given the following code setup: public class Foo { List<string> MyStrings { get; set; } } List<Foo> foos = …

linq-to-objects collections distinct
Most efficient way to remove duplicates from a List

Let's say I have a List with duplicate values and I want to remove the duplicates. List<int> …

c# list distinct
Oracle SQL select distinct query to return specific number of rows

I have a table in an Oracle database with a timestamp column nextTime and a string column destName. There are …

sql oracle query-optimization distinct rownum
When the performance of Distinct and Group By are different?

I know in simple queries the performance and execution plans of the Distinct and Group By are almost the same. …

sql-server tsql group-by distinct
Using SELECT DISTINCT on an already created DataTable object?

I have an already created DataTable object which i am using for my girdview (asp.net) i also need to …

asp.net data-binding datatable distinct asp.net-controls
Hibernate new keyword with distinct

I need to take hql that is currently : select distinct a from Asset as a where ... and change it to …

hibernate hql new-operator distinct