Please enable JavaScript.
Coggle requires JavaScript to display documents.
BASIC-SQL - Coggle Diagram
BASIC-SQL
PROCEDURES
What
Create
Drop
Params
Default
Validation
Output
Variables
Functions
Conventions
FUNCTIONS
Numeric
String
Date
Formatting
Calculate
Conditional
VIEWS
Creating
CREATE VIEW
view_name
AS Select ...
Altering
CREATE OR REPLACE VIEW
view_name
AS Select ...
Dropping
DROP VIEW
view_name
Updatable
Can
Update
Delete
Insert
Requires
Columns
All
Except
Distinct
Aggregate
Group by/Having
Union
WithCheckOption
Prevent
Change
Making
Row
Count
Change
Declare
Create ...
With Check Option
Benefits
Simple
Queries
Impact
Changes
Reduced
Restrict
Access
SUMMARIZE
Aggregate
Functions
Max-Min
Avg
Sum-Count
Can
Dates
Strings
Non-null
Only
Expression
SUM(col * 1.1)
Duplicates
Count(Distinct col)
GroupBy
Using
Aggregate
Function
Record
Each
Combination
Group By col1, col2
Having
Filtering
GroupBy
Only
Cols
In
Select
Rollup
In-MySql
GroupBy .. With Rollup
Apply
Cols
Aggregate
Summarize
COMPLEX
Subquery
Correlated
Reference
Outer
Variable
Slow
SELECT
Alias
Subquery
Select
(Select ...) AS alias1
col2 - (Select alias1) AS alias2
From Tbl
FROM
Alias
Subquery
Select ... From
(subquery) AS tbl
Vs-Joins
Query
Written
In-Both
Operators
IN
Equal
= ANY (query return list)
ALL
Equal
'> (Select Max(col) ...)
'> All (query return list)
ANY
= ANY (query return list)
EXISTS
Performance
Increase
Where Exists (subquery)