paginated_view (view)
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
38 rows where content_extra contains "9" sorted by content
This data as json, testall, testnone, testresponse, CSV (advanced)
content ▼ | content_extra |
---|---|
109 | - 109 - |
119 | - 119 - |
129 | - 129 - |
139 | - 139 - |
149 | - 149 - |
159 | - 159 - |
169 | - 169 - |
179 | - 179 - |
189 | - 189 - |
19 | - 19 - |
190 | - 190 - |
191 | - 191 - |
192 | - 192 - |
193 | - 193 - |
194 | - 194 - |
195 | - 195 - |
196 | - 196 - |
197 | - 197 - |
198 | - 198 - |
199 | - 199 - |
29 | - 29 - |
39 | - 39 - |
49 | - 49 - |
59 | - 59 - |
69 | - 69 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS SELECT content, '- ' || content || ' -' AS content_extra FROM no_primary_key;