Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
Single Table Analysis
Group By
For Each X Column
Where
Logical Condition
AND
Where customer_id = 55
IN
Where customer_id IN (5,6)
LIKE
String Pattern Matching like regex
Exact Match - ''
Unlimited number of characters %anytext%
Exactly one character after or before '%pattern_%'
NOT LIKE - Negation
OR
Where customer_id = 5 OR customer id = 6
Order By
Ascending & Descending
From
Table Name, You can only select one single table.
Select
Columns seperated by commas
DISTINCT
Return Only Distinct Columns
Having
Group Level Filtering