OUPUT DOWN

>> Skill.down
=> [#<Skill id: 705, name: "ZEND STUDIO", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 704, name: "ZEND FRAMEWORK", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 703, name: "Zend", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 702, name: "Z/OS", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 701, name: "Xyleme", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 700, name: "Xtragrid", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 699, name: "XSLT", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 698, name: "XSL", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 697, name: "XMLSpy", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 696, name: "XML XPAth", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 695, name: "XML DOM", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 694, name: "XML", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 693, name: "Xmetal", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 692, name: "XHTML", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 691, name: "XCMON", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 690, name: "Xbase", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 689, name: "WSAD", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 688, name: "WPS", created_at: "2010-07-22 09:00:38", updated_at: "2010-07-22 09:00:38">, #<Skill id: 687, name: "WMS Imaging", created_at: "2010-07-22 09:00:37", updated_at: "2010-07-22 09:00:37">, #<Skill id: 686, name: "Wired for Olap", created_at: "2010-07-22 09:00:37", updated_at: "2010-07-22 09:00:37">]
>> Skill.down.find(:first, :order => "rand()")
=> #<Skill id: 566, name: "Siebel Marketing", created_at: "2010-07-22 09:00:31", updated_at: "2010-07-22 09:00:31">
>> Skill.down.find(:first, :order => "rand()")
=> #<Skill id: 572, name: "Small Talk", created_at: "2010-07-22 09:00:31", updated_at: "2010-07-22 09:00:31">
>> Skill.down.find(:first, :order => "rand()")
=> #<Skill id: 672, name: "Windows", created_at: "2010-07-22 09:00:37", updated_at: "2010-07-22 09:00:37">
>> Skill.down.find(:first, :order => "rand()")
=> #<Skill id: 335, name: "Microsoft Integration Services", created_at: "2010-07-22 09:00:18", updated_at: "2010-07-22 09:00:18">
>> Skill.down.find(:first, :order => "rand()")
=> #<Skill id: 442, name: "Qedit", created_at: "2010-07-22 09:00:24", updated_at: "2010-07-22 09:00:24">

OUPUT TOP

>> Skill.top
=> [#<Skill id: 1, name: ".NET", created_at: "2010-07-22 09:00:00", updated_at: "2010-07-22 09:00:00">, #<Skill id: 2, name: "4GL", created_at: "2010-07-22 09:00:00", updated_at: "2010-07-22 09:00:00">, #<Skill id: 3, name: "ABAP", created_at: "2010-07-22 09:00:00", updated_at: "2010-07-22 09:00:00">, #<Skill id: 4, name: "ABC Flowcharter", created_at: "2010-07-22 09:00:00", updated_at: "2010-07-22 09:00:00">, #<Skill id: 5, name: "Accompagnement à la conduite du changement", created_at: "2010-07-22 09:00:00", updated_at: "2010-07-22 09:00:00">, #<Skill id: 6, name: "Achats", created_at: "2010-07-22 09:00:00", updated_at: "2010-07-22 09:00:00">, #<Skill id: 7, name: "Action Script / Flash", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 8, name: "Actuate", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 9, name: "Actuate eReport Designer", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 10, name: "ADA", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 11, name: "Add in Excel", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 12, name: "Adobe Acrobat", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 13, name: "Adobe Illustrator", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 14, name: "Adobe Photoshop", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 15, name: "Affinium", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 16, name: "AIX", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 17, name: "AJAX", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 18, name: "alfresco", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 19, name: "Alice", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">, #<Skill id: 20, name: "AMO", created_at: "2010-07-22 09:00:01", updated_at: "2010-07-22 09:00:01">]
>> Skill.top.find(:first, :order => "rand()")
=> #<Skill id: 608, name: "Sunopsis V3", created_at: "2010-07-22 09:00:33", updated_at: "2010-07-22 09:00:33">
>> Skill.top.find(:first, :order => "rand()")
=> #<Skill id: 231, name: "Hyperion Analyzer", created_at: "2010-07-22 09:00:13", updated_at: "2010-07-22 09:00:13">
>> Skill.top.find(:first, :order => "rand()")
=> #<Skill id: 435, name: "Proc SQL", created_at: "2010-07-22 09:00:24", updated_at: "2010-07-22 09:00:24">
>> Skill.top.find(:first, :order => "rand()")
=> #<Skill id: 594, name: "Struts", created_at: "2010-07-22 09:00:32", updated_at: "2010-07-22 09:00:32">
>> Skill.top.find(:first, :order => "rand()")
=> #<Skill id: 624, name: "TNG", created_at: "2010-07-22 09:00:34", updated_at: "2010-07-22 09:00:34">

skill.rb

class Skill < ActiveRecord::Base
  ## Plugins ##

  ## Callbacks ##

  ## Relations ##
  has_many :trainings

  ## Validates ##
  validates_presence_of :name
  validates_uniqueness_of :name

  ## Scopes ##
  default_scope :order => :name
  named_scope :top, :order => "skills.name ASC", :limit => 20
  named_scope :down, :order => "skills.name DESC", :limit => 20

  ## Methods ##
end