The two queries express the same question. Apparently the query optimizer chooses two different execution plans. My guess would be that the distinct approach is executed like: Copy all business_key values to a temporary table Sort the temporary table Scan the temporary table, returning each item that is different from the one before it The … Read more
How about something like: SELECT mt.* FROM MyTable mt INNER JOIN ( SELECT id, MIN(record_date) AS MinDate FROM MyTable GROUP BY id ) t ON mt.id = t.id AND mt.record_date = t.MinDate This gets the minimum date per ID, and then gets the values based on those values. The only time you would have duplicates … Read more
Link to Working Examples Solution 0 This can be accompished using pivot tables. Solution 1 Use the unique formula to get all the distinct values. Then use countif to get the count of each value. See the working example link at the top to see exactly how this is implemented. Unique Values Count =UNIQUE(A3:A8) =COUNTIF(A3:A8;B3) … Read more
I know that the question is too old, anyway: SELECT a, b FROM mytable GROUP BY a, b; This will give your all the combinations.
Here’s a snippet of hql that we use. (Names have been changed to protect identities) String queryString = “select distinct f from Foo f inner join foo.bars as b” + ” where f.creationDate >= ? and f.creationDate < ? and b.bar = ?”; return getHibernateTemplate().find(queryString, new Object[] {startDate, endDate, bar});
StringComparer does what you need: List<string> list = new List<string>() { “One”, “Two”, “Three”, “three”, “Four”, “Five” }; var distinctList = list.Distinct( StringComparer.CurrentCultureIgnoreCase).ToList(); (or invariant / ordinal / etc depending on the data you are comparing)
Have you tried to specify the :uniq option on the has_many association: has_many :products, :through => :orders, :uniq => true From the Rails documentation: :uniq If true, duplicates will be omitted from the collection. Useful in conjunction with :through. UPDATE FOR RAILS 4: In Rails 4, has_many :products, :through => :orders, :uniq => true is … Read more
The following should work $ad->getcodes()->distinct()->count(‘pid’);
One way to get the list of distinct column names from the database is to use distinct() in conjunction with values(). In your case you can do the following to get the names of distinct categories: q = ProductOrder.objects.values(‘Category’).distinct() print q.query # See for yourself. # The query would look something like # SELECT DISTINCT … Read more
Using lambda expression.. var result = EFContext.TestAddresses.Select(m => m.Name).Distinct(); Another variation using where, var result = EFContext.TestAddresses .Where(a => a.age > 10)//if you have any condition .Select(m => m.name).Distinct(); Another variation using sql like syntax var result = (from recordset in EFContext.TestAddresses .where(a => a.city = ‘NY’)//if you have any condition .select new { recordset.name … Read more