SELECT stolpec1, stolpec2, stolpec3 - stolpec4 AS ime, ...., *
FROM tabela AS t
WHERE (pogoj OR (stolpec1 = stolpec2 + stolpec3))
AND stolpec4 LIKE '_=%' -- npr. 'a=123'
AND id IN (
SELECT stolpec FROM tabela
WHERE t.stolpec = id
)
ORDER BY stolpec1 ASC, stolpec2 DESC
LIMIT 10
SELECT
basicsNaloga | TA | ŽA | AB | PK | KK | AL | JL | HL | MM | AO | DR | BR | AS | MS | DŠ | LT | TT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 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 | ||||
3 | x | x | x | x | x | x | x | x | x | x | x | x | x |
SELECT
from world
Naloga | TA | ŽA | AB | PK | KK | AL | JL | HL | MM | AO | DR | BR | AS | MS | DŠ | LT | TT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | x | x | x | x | x | x | x | x | x | x | x | x |
SELECT
from nobel
Naloga | TA | ŽA | AB | PK | KK | AL | JL | HL | MM | AO | DR | BR | AS | MS | DŠ | LT | TT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 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 | ||||
3 | 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 | ||||
5 | 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 | ||||
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 | ||||
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 | ||||
11 | 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 | |||||
13 | x | x | x | x | x | x | x | x | x | x | x | x | |||||
14 | x | x | x | x | x | x | x | x | x | x | x | x |
SELECT
within SELECT
Naloga | TA | ŽA | AB | PK | KK | AL | JL | HL | MM | AO | DR | BR | AS | MS | DŠ | LT | TT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | x | x | x | x | x | x | x | x | x | x | x | ||||||
2 | x | x | x | x | x | x | x | x | x | x | x | ||||||
3 | x | x | x | x | x | x | x | x | x | x | x | ||||||
4 | x | x | x | x | x | x | x | x | x | ||||||||
5 | x | x | x | x | x | x | x | x | x | x | x | ||||||
6 | x | x | x | x | x | x | x | x | x | ||||||||
7 | x | x | x | x | x | x | x | x | x | ||||||||
8 | x | x | x | x | x | x | x | x | x | ||||||||
9 | x | x | x | x | x | x | x | ||||||||||
10 | 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