Top "Distinct" questions

Using DISTINCT inner join in SQL

I have three tables, A, B, C, where A is many to one B, and B is many to one …

sql distinct inner-join

Select unique or distinct values from a list in UNIX shell script

I have a ksh script that returns a long list of values, newline separated, and I want to see only …

bash unique distinct ksh sh

How to use DISTINCT and ORDER BY in same SELECT statement?

After executing the following statement: SELECT Category FROM MonitoringJob ORDER BY CreationDate DESC I am getting the following values from …

sql sql-order-by distinct

Laravel Eloquent - distinct() and count() not working properly together

So I'm trying to get the number of distinct pids on a query, but the returned value is wrong. This …

laravel count eloquent distinct

Using .Select and .Where in a single LINQ statement

I need to gather Distinct Id's from a particular table using LINQ. The catch is I also need a WHERE …

c# linq unique distinct

How do you create a Distinct query in HQL

Is there a way to create a Distinct query in HQL. Either by using the "distinct" keyword or some other …

hibernate hql distinct

Is there any difference between GROUP BY and DISTINCT

I learned something simple about SQL the other day: SELECT c FROM myTbl GROUP BY C Has the same result …

sql group-by distinct

Entity Framework select distinct name

How can I do this SQL query with Entity Framework? SELECT DISTINCT NAME FROM TestAddresses

c# linq entity-framework distinct

DISTINCT clause with WHERE

How can I use the DISTINCT clause with WHERE? For example: SELECT * FROM table WHERE DISTINCT email; -- email is …

sql distinct where

What's faster, SELECT DISTINCT or GROUP BY in MySQL?

If I have a table CREATE TABLE users ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL, profession …

mysql sql database group-by distinct