Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group By or Distinct to return only unique results?

Status
Not open for further replies.

postermmxvicom

Programmer
Jun 25, 2007
114
US
I want my query to only return unique results. I have made acceptable queries using either Group By or Distinct. I read that you can't trust DISTINCT to de-duplicate correctly in some situations. Does Group By suffer from any issues? Is there any other differences that I should be aware of? Is one better than the other?

I had another question, but this faq701-3274 answered it. Thanks, randysmid!

One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top