Please enable JavaScript.
Coggle requires JavaScript to display documents.
RETRIEVE - Coggle Diagram
RETRIEVE
MULTIPLE
Table
Joins
Inner
JOIN t2
ON
t1.col
=
t2.col
AcrossDB
JOIN ot_db.tbl
Self
Alias
Required
Table
Column
Compound
Multiple
Id
Required
Identify
JOIN tbl ON ... AND ...
Implicit
FROM
tbl1
tbl2
WHERE
Condition
Outer
Types
LEFT
Use
Only
RIGHT
Includes
Direction
Columns
Condition
Irrespective
Multiple
Self
USING
Columns
Same
Name
Replace
ON
USING (col1, col2)
Natural
Engine
Automatic
NATURAL JOIN tbl
Discouraged
Cross
CROSS JOIN tbl
Implicit
FROM tbl1, tbl2
Usecase
Combine
Size
Colors
Unions
Rows
Combine
Columns
Count
Same
Label
Based
Table
First
SINGLE
Table
Select
Columns
All
*
Some
Comma
Arithmetic
Col + x
Alias
AS m_alias
Unique
DISTINCT col
Where
Filtering
Comparison
gt
gte
lt
lte
eq
ne
<>
Logical
AND
OR
NOT
Range
Between
col B/W val1 and val2
Inclusive
Both
Date
Used
YYYY-MM-DD
IN
col [NOT] IN (vals,...)
Pattern
REGEXP
col REGEXP 'pattern'
^
$
|
[gim]e
gi/ie/me
Range
[a-h]
[a-z]
LIKE
%
*
_
?
col LIKE "%b"
Insensitive
Others
ORDER BY
Sort
Default
PK
ORDER BY col1, col2 ASC/DESC
Weight
col1
Expression
ORDER BY col1 * col2
Can
Unavailable
Select
Alias
Avoid
ColPosition
LIMIT
LIMIT [offset] count
Set
Start
Pagination
IS NULL
STATEMENT
Common
USE
Database
Comment
-- Abc
Order
Select
From
Where
Order By
Limit
Join