# Rails 2 to Rails 3 - How to convert this sql query? **URL:** \ **Category:** Rails\ **Created:** [September 8, 2010, 2:31pm UTC](https://www.ruby-forum.com/t/rails-2-to-rails-3-how-to-convert-this-sql-query/194649 "2010-09-08T14:31:29Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![dme69](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@dme69](https://www.ruby-forum.com/u/dme69)\ **Post date:** [September 8, 2010, 2:31pm UTC](https://www.ruby-forum.com/t/rails-2-to-rails-3-how-to-convert-this-sql-query/194649/1 "2010-09-08T14:31:29Z")
Hello all, Can someone help me with this query ? Here is the query used in rails 2. The idea here is to obtain the top 10 widgets. Widget.find(:all, :select =\> ‘widget\_type\_id, COUNT(widget\_type\_id) AS widgettypeid’, :group =\> ‘widget\_type\_id’, :order =\> ‘widgettypeid DESC’, :limit =\> 10) This is deprecated and i want to port it to rails 3. Thanks for your help. Dominique. ---
**Author:** ![dme69](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@dme69](https://www.ruby-forum.com/u/dme69)\ **Post date:** [September 8, 2010, 3:43pm UTC](https://www.ruby-forum.com/t/rails-2-to-rails-3-how-to-convert-this-sql-query/194649/2 "2010-09-08T15:43:29Z")
I’m not sure how to do the “COUNT(widget\_type\_id) AS widgettypeid” as this doesn’t seem to work below but it is close. hoping someone will chime in. 🙂 I’m sure I’m missing something simple. Widget.group(:widget\_type\_id).select(‘widget\_type\_id, count(widget\_type\_id) AS widgettypeid’).order(:widgettypeid).limit(10) No docs on this at [http://api.rubyonrails.org/classes/ActiveRecord/QueryMethods.html#method-i-group](http://api.rubyonrails.org/classes/ActiveRecord/QueryMethods.html#method-i-group) but guide has some examples. > **[Active Record Query Interface — Ruby on Rails Guides](https://guides.rubyonrails.org/active_record_querying.html)** > > Active Record Query InterfaceThis guide covers different ways to retrieve data from the database using Active Record.After reading this guide, you will know: How to find records using a variety of methods and conditions. How to specify the order,... ---
**Author:** ![dme69](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a88e4f/32.png) [@dme69](https://www.ruby-forum.com/u/dme69)\ **Post date:** [September 8, 2010, 3:55pm UTC](https://www.ruby-forum.com/t/rails-2-to-rails-3-how-to-convert-this-sql-query/194649/3 "2010-09-08T15:55:13Z")
Great ! This seems to work perfectly for me. Thanks for your help. I will take a big look at this to understand how it is working. Dominique.