• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Finally, you can manage your Google Docs, uploads, and email attachments (plus Dropbox and Slack files) in one convenient place. Claim a free account, and in less than 2 minutes, Dokkio (from the makers of PBworks) can automatically organize your content for you.



Page history last edited by wikiuser0007 1 year, 7 months ago

"between": wählt die Werte aus die zwischen zwei ausgewählten Werten liegen.

Beispiel: SELECT * FROM Products WHERE Price BETWEEN 10 AND 20;


"in": erlaubt es dir verschiedene Werte im WHERE Teil zu spezifizieren.

Beispiel: SELECT * FROM Customers WHERE County IN ('Germany', 'France', 'UK');


"exists": wird benutzt um zu testen ob etwas in einer "subquery" existiert.

Beispiel: SELECT SupplierName FROM Suppliers WHERE EXISTS (SELECT ProductName FROM Products WHERE Products.SupplierID = Suppliers.supplierID AND Price < 20);


Comments (0)

You don't have permission to comment on this page.