paginated_view (view)

38 rows where content_extra contains "9"

✎ View and edit SQL

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

content content_extra
9 - 9 -
19 - 19 -
29 - 29 -
39 - 39 -
49 - 49 -
59 - 59 -
69 - 69 -
79 - 79 -
89 - 89 -
90 - 90 -
91 - 91 -
92 - 92 -
93 - 93 -
94 - 94 -
95 - 95 -
96 - 96 -
97 - 97 -
98 - 98 -
99 - 99 -
109 - 109 -
119 - 119 -
129 - 129 -
139 - 139 -
149 - 149 -
159 - 159 -

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;