paginated_view (view)

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

201 rows sorted by content_extra descending

View and edit SQL

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 -

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 9.952ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette