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 ▲
76 - 76 -
75 - 75 -
74 - 74 -
73 - 73 -
72 - 72 -
71 - 71 -
70 - 70 -
7 - 7 -
69 - 69 -
68 - 68 -
67 - 67 -
66 - 66 -
65 - 65 -
64 - 64 -
63 - 63 -
62 - 62 -
61 - 61 -
60 - 60 -
6 - 6 -
59 - 59 -
58 - 58 -
57 - 57 -
56 - 56 -
55 - 55 -
54 - 54 -

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