select

1 row sorted by having

View and edit SQL

Link rowid group having ▼ and json
1 group having and {"href": "http://example.com/", "label":"Example"}

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [select] (
  [group] text,
  [having] text,
  [and] text,
  [json] text
);
Powered by Datasette · Query took 8.163ms