analysis

7 rows where family = 021

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ name family
0210012300 LA BAU 2003 Diverse 021
0210012500 Der private Baumarkt 2005 Diverse 021
0210012800 Der private Baumarkt 2008 Diverse 021
0210013100 Der private Baumarkt 2011 Diverse 021
0210013200 Der private Baumarkt 2012 Diverse 021
0210013400 Der private Baumarkt 2014 Diverse 021
0210013600 Der private Baumarkt 2016 Diverse 021

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE analysis (
	id VARCHAR(10) NOT NULL, 
	name VARCHAR(250), 
	family VARCHAR(3), 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(family) REFERENCES families (id)
);