Tim Shaffer wrote in post #975719: > Queries don't really work that way. You can't really select the full > record when using distinct client_category. > > Lets say you have the following rows: > > client_category, client_name > Cat1, Foo > Cat1, Bar > Cat2, Other > > 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. -- 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.