On Feb 16, 2:36 pm, Jason Thomas <[email protected]> wrote: > Is there an easy way to return additional columns when finding the min > or max in a particular column? > > For example: > data_table: > | date | value | > | 2011 | 10 > | 2010 | 5 > > DB[:data_table].min(:value) => 5 > > I also want to see 2010 in the result as well.
Then you don't just want the minimum value, which is what #min returns. My guess is you want all rows where value equals the minimum value: DB[:data_table].filter(:value=>DB[:data_table].min(:value)).all Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-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/sequel-talk?hl=en.
