paginated_view (view)
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
201 rows sorted by content_extra descending
This data as json, testall, testnone, testresponse, CSV (advanced)
content | content_extra ▲ |
---|---|
99 | - 99 - |
98 | - 98 - |
97 | - 97 - |
96 | - 96 - |
95 | - 95 - |
94 | - 94 - |
93 | - 93 - |
92 | - 92 - |
91 | - 91 - |
90 | - 90 - |
9 | - 9 - |
89 | - 89 - |
88 | - 88 - |
87 | - 87 - |
86 | - 86 - |
85 | - 85 - |
84 | - 84 - |
83 | - 83 - |
82 | - 82 - |
81 | - 81 - |
80 | - 80 - |
8 | - 8 - |
79 | - 79 - |
78 | - 78 - |
77 | - 77 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS SELECT content, '- ' || content || ' -' AS content_extra FROM no_primary_key;