paginated_view (view)

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

201 rows

✎ View and edit SQL

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

content content_extra
26 - 26 -
27 - 27 -
28 - 28 -
29 - 29 -
30 - 30 -
31 - 31 -
32 - 32 -
33 - 33 -
34 - 34 -
35 - 35 -
36 - 36 -
37 - 37 -
38 - 38 -
39 - 39 -
40 - 40 -
41 - 41 -
42 - 42 -
43 - 43 -
44 - 44 -
45 - 45 -
46 - 46 -
47 - 47 -
48 - 48 -
49 - 49 -
50 - 50 -

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;