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

  • Stop wasting time looking for files and revisions. Connect your Gmail, DriveDropbox, and Slack accounts and in less than 2 minutes, Dokkio will automatically organize all your file attachments. Learn more and claim your free account.

View
 

SQL_Platzhalter

Page history last edited by wikiuser0007 10 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.