items = Model .where(first_name: 'Harvey') .where('id = 3') .where('id = ?', 3) .order(:title) .order(title: :desc) .order("title DESC") .reorder(:title) # discards other .order's .rewhere(...) # discards other .where's .limit(2) .offset(1) .uniq See: QueryMethods items = Model .select(:id) .select([:id, :name]) .group(:name) # GROUP BY name .group('name AS grouped_name, age') .having('SUM(price)