Cheatography
https://cheatography.com
Because I never recall how to write anything after "UPDATE".
SELECT ... JOIN ... WHERE
SELECT
|
a.COL1
|
AS 'a1',
|
| |
a.COL2
|
AS 'a2',
|
| |
c.COL1
|
AS 'c1'
|
FROM
|
TBL1 a
|
(WHATEVER) JOIN
|
TBL2 b
|
ON b.X = a.Y
|
(WHATEVER) JOIN
|
TBL3 c
|
ON c.K = b.K
|
WHERE
|
a.K = b.K
|
AND
|
c.Z = 'foobar'
|
GROUP BY
|
a.COL1,
|
-- basically specify |
| |
a.COL2,
|
-- all selected columns |
| |
c.COL1
|
-- when "GROUP BY" |
ORDER BY
|
b.Q
|
("sub-query")
WHERE
|
COL1 IN (
|
| |
SELECT
|
COL1
|
| |
FROM
|
TBL337 x
|
| |
(WHATEVER) JOIN
|
...
|
| |
WHERE
|
x.Z = 'sub'
|
| |
)
|
|
|
CTE
WITH
|
TEMP
|
AS (
|
| |
SELECT
|
foo
|
| |
FROM
|
tbl1
|
| |
UNION ALL
|
| |
SELECT
|
b.foo
|
| |
FROM
|
TEMP a
|
| |
INNER JOIN
|
tbl1 b
|
| |
ON
|
b.foo
|
= a.foo
|
)
|
SELECT
|
*
|
FROM
|
TEMP
|
OPTION
|
(MAXRECURSION 5)
|
UPDATE ... JOIN ... WHERE
UPDATE
|
TBL1
|
SET
|
COL1 = 'GOD',
|
| |
COL2 = 'AWFUL'
|
FROM
|
TBL1 a
|
(WHATEVER) JOIN
|
TBL2 b
|
ON b.X = a.Y
|
WHERE
|
b.Q
|
IN ('bull', 'shit')
|
|
Created By
https://twitter.com/yuptogun
https://twitter.com/yuptogun
Metadata
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets