home / fixtures / paginated_view

Menu

paginated_view (view)

202 rows

✎ View and edit SQL

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

content content_extra
51 - 51 -
52 - 52 -
53 - 53 -
54 - 54 -
55 - 55 -
56 - 56 -
57 - 57 -
58 - 58 -
59 - 59 -
60 - 60 -
61 - 61 -
62 - 62 -
63 - 63 -
64 - 64 -
65 - 65 -
66 - 66 -
67 - 67 -
68 - 68 -
69 - 69 -
70 - 70 -
71 - 71 -
72 - 72 -
73 - 73 -
74 - 74 -
75 - 75 -

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 · Queries took 1.2ms