SELECT stolpci
FROM tabela1 [LEFT | RIGHT | FULL] JOIN tabela2
ON pogoj AND tabela1.st1 = tabela2.st2
JOIN tabela3 USING (st1, st2, st3)
NATURAL JOIN tabela4
WHERE pogoj
GROUP BY stolpci
HAVING pogoj
ORDER BY stolpci
LIMIT stevilo
JOIN
operationNaloga | DA | DB | MČ | AG | HKK | LM | MO | SO | MP | TP | PR | TS | LŠ | AT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
2 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
3 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
4 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
5 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
6 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
7 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
8 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
9 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
10 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
11 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
12 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
13 | X | X | / | / | / | / | / |
JOIN
operationsNaloga | DA | DB | MČ | AG | HKK | LM | MO | SO | MP | TP | PR | TS | LŠ | AT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
2 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
3 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
4 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
5 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
6 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
7 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
8 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
9 | X | x | X | x | X | X | X | X | X | X | X | X | X | |
10 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
11 | x | X | x | X | x | X | X | X | X | X | X | X | X | X |
12 | X | x | X | X | X | X | X | X | X | X | ||||
13 | X | X | X | X | X | X | X | X | ||||||
14 | X | X | X | X | X | X | X | X | ||||||
15 | X | X | X | X | X | X | X |
or
or
By clicking below, you agree to our terms of service.
New to HackMD? Sign up
Syntax | Example | Reference | |
---|---|---|---|
# Header | Header | 基本排版 | |
- Unordered List |
|
||
1. Ordered List |
|
||
- [ ] Todo List |
|
||
> Blockquote | Blockquote |
||
**Bold font** | Bold font | ||
*Italics font* | Italics font | ||
~~Strikethrough~~ | |||
19^th^ | 19th | ||
H~2~O | H2O | ||
++Inserted text++ | Inserted text | ||
==Marked text== | Marked text | ||
[link text](https:// "title") | Link | ||
 | Image | ||
`Code` | Code |
在筆記中貼入程式碼 | |
```javascript var i = 0; ``` |
|
||
:smile: | ![]() |
Emoji list | |
{%youtube youtube_id %} | Externals | ||
$L^aT_eX$ | LaTeX | ||
:::info This is a alert area. ::: |
This is a alert area. |
On a scale of 0-10, how likely is it that you would recommend HackMD to your friends, family or business associates?
Please give us some advice and help us improve HackMD.
Syncing