DISQUS

Tech-Recipes: Ignore duplicate entries in MySQL select using DISTINCT keyword | MySQL | Tech-Recipes

  • ViserExcizer · 9 months ago
    I;ve experimented with both GROUP BY and DISTINCT fucntions in select statements, for some reason, distinct doesn't behave the way it should, for me when the array is fetched in a loop
  • mistat · 4 months ago
    Works a charm - just what I was looking for - thanks!
  • maverick · 3 months ago
    How do you select query with multiple columns unique distinct values from a single column?

    statement:
    select givenname, party from presidents;

    I want only the givenname to be distinct and not the party?
  • tayeb · 1 week ago
    hey maverick i was just wondering if u got the answer to ur question ????
    am having the same problem ...
    thanx
  • chandan · 2 months ago
    some weird distinct in mysql 5.0.1 version :(