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

  • Social distancing? Try a better way to work remotely on your online files. Dokkio, a new product from PBworks, can help your team find, organize, and collaborate on your Drive, Gmail, Dropbox, Box, and Slack files. Sign up for free.



Page history last edited by wikiuser0007 6 months, 1 week 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.