paginated_view (view)

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

201 rows sorted by content_extra

View and edit SQL

content content_extra ▼
121 - 121 -
122 - 122 -
123 - 123 -
124 - 124 -
125 - 125 -
126 - 126 -
127 - 127 -
128 - 128 -
129 - 129 -
13 - 13 -
130 - 130 -
131 - 131 -
132 - 132 -
133 - 133 -
134 - 134 -
135 - 135 -
136 - 136 -
137 - 137 -
138 - 138 -
139 - 139 -
14 - 14 -
140 - 140 -
141 - 141 -
142 - 142 -
143 - 143 -

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW paginated_view AS
    SELECT
        content,
        '- ' || content || ' -' AS content_extra
    FROM no_primary_key;
Powered by Datasette · Query took 5.013ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette