Limit offset : Map to SQL « ActiveRecord « Ruby

Home
Ruby
1.ActiveRecord
2.Array
3.CGI
4.Class
5.Collections
6.Database
7.Date
8.Design Patterns
9.Development
10.File Directory
11.GUI
12.Hash
13.Language Basics
14.Method
15.Network
16.Number
17.Rails
18.Range
19.Reflection
20.Statement
21.String
22.Threads
23.Time
24.Tk
25.Unit Test
26.Windows Platform
27.XML
Ruby » ActiveRecord » Map to SQL 
Limit offset


Account.find :all, :limit => 10, :offset => 20

And the following SQL query will result:

SELECT FROM accounts LIMIT 10 OFFSET 20

 
Related examples in the same category
1.The :order parameter defines the sorting order.
2.Group by clause
3.Aggregate function and group by
4.Left join
5.Left join on a column
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.