name | vorname | strasse | ort |
Muschter | Felix | Luchsweg | Wetzikon |
Behr | Pascal | Staustrasse | Uster |
Steiner | Sandra | Rainstrasse | Zürich |
Bertsmann | Anna | Im Riet | Wetzikon |
SELECT * FROM patienten_cisp ; |
SELECT name, vorname FROM patienten_cisp ; |
Muschter | Felix |
Behr | Pascal |
Steiner | Sandra |
Bertsmann | Anna |
SELECT name, vorname FROM patienten_cisp WHERE name = 'Behr' ; |
SELECT name, vorname FROM patienten_cisp WHERE name LIKE 'Be%' ; |
Behr | Pascal |
Bertsmann | Anna |