On Tuesday 08 September 2009 04:36:14 pm Paul McNett wrote: > John wrote: > > On Tuesday 08 September 2009 02:57:29 pm Paul McNett wrote: > >> Paul McNett wrote: > >>> When do you need DISTINCT? I've written tons of SQL over the past 15 > >>> years and have never found the need for it. > >> > >> Specifically, what is the benefit of using DISTINCT over GROUP BY? > >> > >> Paul > > > > How would re-write the SQL I provided. > > Just so you know, I wasn't being rhetorical. I thought that there must be a > gap in my knowledge so I really wanted to know. Re-reading my response made > me almost blush at the rudeness of it. > > Sorry! > > Paul
No worries. I guess I got to using distinct because I'm not using aggregate functions (that's one of the differences). In this case I'm not using aggregate functions - just a bunch subqueries. I don't even like the subqueries. I think I can just use a filter. Johnf _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/200909081824.22904.jfabi...@yolo.com