v1.2.6 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::OracleAdapter
distinct(columns, order_by) public

SELECT DISTINCT clause for a given set of columns and a given ORDER BY clause.

Oracle requires the ORDER BY columns to be in the SELECT list for DISTINCT queries. However, with those columns included in the SELECT DISTINCT list, you won’t actually get a distinct list of the column you want (presuming the column has duplicates with multiple values for the ordered-by columns. So we use the FIRST_VALUE function to get a single (first) value for each column, effectively making every row the same.

  distinct("posts.id", "posts.created_at desc")
Show source
Register or log in to add new notes.