paginated_view (view)

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

201 rows sorted by content

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

content ▼ content_extra
1 - 1 -
10 - 10 -
100 - 100 -
101 - 101 -
102 - 102 -
103 - 103 -
104 - 104 -
105 - 105 -
106 - 106 -
107 - 107 -
108 - 108 -
109 - 109 -
11 - 11 -
110 - 110 -
111 - 111 -
112 - 112 -
113 - 113 -
114 - 114 -
115 - 115 -
116 - 116 -
117 - 117 -
118 - 118 -
119 - 119 -
12 - 12 -
120 - 120 -

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;