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