Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
Order of execution
From
Join
Inner join / join
Left join
Right join
Full join
Where
Predicates
And
Between
Is null
Is not null
In
Or
Operators :
Arithmetic operators
Comparision operators
Like
Logical operators
Set operatos
Group by
Having
Order by
Asc
Desc
Select
Functions
Built in functions
Aggregate functions :
Sum
Avg
Count
Min
Max
String functions :
Concat
Left
Right
Length
Lower
Upper
Ltrim
Rtrim
Trim
Replace
Strcmp
Substring
Mathematical functions
Floor
Ceil
Power
Round
Abs
Mod
User defined functions