SELECT [DISTINCT] grp_stolpec, SUM(stolpec), COUNT([* | [DISTINCT] stolpec]), ...
FROM tabela
WHERE stolpec [> | < | >= | <= | = | <>] [ALL | ANY] (
SELECT ...
) AND stolpec IS [NOT] NULL
GROUP BY grp_stolpec
HAVING pogoj
SELECT
Naloga | DA | DB | MČ | AG | HKK | LM | MO | SO | MP | TP | PR | TS | LŠ | AT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
SUM
in COUNT
Naloga | 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 |
nobel
Naloga | 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 | |
8 | 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 |
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