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 |
---|---|
9 | - 9 - |
19 | - 19 - |
29 | - 29 - |
39 | - 39 - |
49 | - 49 - |
59 | - 59 - |
69 | - 69 - |
79 | - 79 - |
89 | - 89 - |
90 | - 90 - |
91 | - 91 - |
92 | - 92 - |
93 | - 93 - |
94 | - 94 - |
95 | - 95 - |
96 | - 96 - |
97 | - 97 - |
98 | - 98 - |
99 | - 99 - |
109 | - 109 - |
119 | - 119 - |
129 | - 129 - |
139 | - 139 - |
149 | - 149 - |
159 | - 159 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS SELECT content, '- ' || content || ' -' AS content_extra FROM no_primary_key;