Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu04:theorie:a_syntax [2024/08/30 11:25] – vdemir
+++ modul:m290:learningunits:lu04:theorie:a_syntax [2024/10/17 12:33] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU04a - Syntax of DML ======
+====== LU06a - Syntax of a DQL-Select statement ======
-As we know, **SQL** stands for **S**tructured **Q**uery **L**anguage. Consequently, It should come as no surprise that SQL is indeed consistently structured.
+As we know, **SQL** stands for **S**tructured **Q**uery **L**anguage. Consequently, It should come as no surprise that SQL is indeed consistently structured. The figure below shows the  structure of a exhaustive SQL statement.
+{{:modul:m290:learningunits:lu04:theorie:sql-syntax.png?600|}}
 ===== NOTES  =====
-  * The content of this chapter is based on the  [[https://www.w3schools.com/sql/sql_syntax.asp|W3School-SQL-tutorial]]
+  * The content of this chapter is based on the  [[https://www.w3schools.com/sql/sql_syntax.asp|W3School-SQL-tutorial]].
   * Please note that the use og CAPITAL LETTERS for SQL commands and tabs can make it easier for you to maintain your program code.
+  * Make sure, that every complete sql statement is finished by a semicolon (;).
 ===== The Syntax of DML commands =====
@@ Zeile 45: / Zeile 48: @@
 ^ English ^ German ^
 | precondition | Vorbedingung |
+| exhaustive  | erschöpfend, vollständig |
 | clause | Abschnitt |
 | to determine | bestimmen |