Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL Retrieval (Relationship operators (= - Equal to, < - Less than, <…
SQL Retrieval
Relationship operators
-
-
-
-
= - Greater than or equal to
-
-
-
-
Duplicates can occur as you are only viewing a portion of the columns in a table, to avoid this we use the keyword DISTINCT after the SELECT
-
-
-
In a SELECT statement the SELECT clause allows you to chose the column, the FROM specifies the table
Most SQL command processors are not case sensitive, but most DBMS are case sensitive when it comes to matching data values