Code to display the SQL query from an ActiveRecord Search & to limit number of results returned. From the ransack gem demo.

sql_limit_return.erb

<p>SQL: <%= @users.to_sql %></p>

<h2>Your first #{search_limit} results</h2>

<table>
  <thead>
    <th><%= sort_link @search, :id, {}, :method => action_name == 'advanced_search' ? :post : :get %></th>
    <th><%= sort_link @search, :first_name, {}, :method => action_name == 'advanced_search' ? :post : :get %></th>
    # ...
  </thead>
  <tbody>
    <% @users.limit(search_limit).each do |user| %>
      <tr>
        <td><%= user.id %></td>
        <td><%= user.first_name %></td>
        # ...
      </tr>
    <% end %>
  </tbody>
</table>