On 18 January 2011 16:07, James Byrne <li...@ruby-forum.com> wrote: > Colin Law wrote in post #975727: >> On 18 January 2011 15:14, James Byrne <li...@ruby-forum.com> wrote: >>>> >>>> If you are selecting distinct client_category, and want the full row, >>>> which >>>> of the two "Cat1" rows should it return? >>> >>> What I want to accomplish is to obtain one example of each value and the >>> entire row that contains it. How does one do that? I do not care which >>> row is returned but I only want one row for each distinct value. >> >> Why? If you do not care which row is returned then presumably you do >> not care what is in the rest of the row so why do you need it? >> >> Colin > > Because I want one representative row for each category.
I am interested to know why, when you do not care what the rest of the row contains. Colin > > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.