Array ( [0] => 15488410 [id] => 15488410 [1] => cswiki [site] => cswiki [2] => SELECT [uri] => SELECT [3] => [img] => [4] => [day_avg] => [5] => [day_diff] => [6] => [day_last] => [7] => [day_prev_last] => [8] => [oai] => [9] => [is_good] => [10] => [object_type] => [11] => 0 [has_content] => 0 [12] => [oai_cs_optimisticky] => ) Array ( [0] => [[SQL]] příkaz '''SELECT''' vrací [[množina|množinu]] záznamů z jedné a nebo více [[tabulka|tabulek]]. [1] => [2] => == Syntaxe == [3] => [4] => SELECT [5] => [ALL | DISTINCT] [6] => {[tabulka. | alias. | pohled.]{* | sloupec | sloupec AS alias} [7] => | AVG([tabulka. | alias. | pohled.]) [AS ] [8] => | MIN([tabulka. | alias. | pohled.]) [AS ] [9] => | MAX([tabulka. | alias. | pohled.]) [AS ] [10] => | COUNT([tabulka. | alias. | pohled.]<* | sloupec>) [AS ] [11] => }[,...n] [12] => [13] => [INTO jméno_nové_tabulky] [14] => [15] => FROM [AS ][,... n] [16] => [17] => [[INNER | FULL] JOIN ON [18] => | OUTER JOIN ON [19] => | CROSS JOIN [20] => [AS ] [21] => [,... n]] [22] => [23] => [WHERE [24] => | [25] => | [26] => | BETWEEN AND [27] => | LIKE [28] => | IN [29] => | ANY | SOME (poddotaz) [30] => | EXISTS (poddotaz)] [31] => [32] => [GROUP BY [,... n]] [33] => [HAVING ] [34] => [ORDER BY [,... n] [ASC | DESC]] [35] => [36] => [UNION