On 18 January 2011 16:07, James Byrne <[email protected]> wrote: > Colin Law wrote in post #975727: >> On 18 January 2011 15:14, James Byrne <[email protected]> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
