where句 や order by句 を使いながらgroup by するサンプル
@order = Order.select('max(seq) as seq, max(price) as price')
@order = @order.where('price >= ?', 5000)
@order = @order.group('group1, group2')
@order = @order.order('max(price) desc')
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme