Sha256: e3708e200b13831fd69f24b288f6944266e9041d17a49967d8e86c214c3709d0
Contents?: true
Size: 899 Bytes
Versions: 5
Compression:
Stored size: 899 Bytes
Contents
- alf: |-
page(suppliers, [[:city, :desc], [:sid, :asc]], 1, page_size: 10)
sql: |-
SELECT t1.sid, t1.name, t1.status, t1.city
FROM suppliers AS t1
ORDER BY t1.city DESC, t1.sid ASC
LIMIT 10 OFFSET 0
#
- alf: |-
page(suppliers, [[:city, :desc], [:sid, :asc]], -1, page_size: 10)
sql: |-
SELECT t1.sid, t1.name, t1.status, t1.city
FROM suppliers AS t1
ORDER BY t1.city ASC, t1.sid DESC
LIMIT 10 OFFSET 0
#
- alf: |-
page(suppliers, [[:city, :desc], [:sid, :asc]], 2, page_size: 10)
sql: |-
SELECT t1.sid, t1.name, t1.status, t1.city
FROM suppliers AS t1
ORDER BY t1.city DESC, t1.sid ASC
LIMIT 10 OFFSET 10
#
- alf: |-
page(suppliers, [[:city, :desc]], 2, page_size: 10)
sql: |-
SELECT t1.sid, t1.name, t1.status, t1.city
FROM suppliers AS t1
ORDER BY t1.city DESC, t1.sid ASC
LIMIT 10 OFFSET 10
Version data entries
5 entries across 5 versions & 1 rubygems