SQL (postgres) |
1 | sql |
2 | with |
3 | select |
4 | from |
5 | where |
6 | group by |
7 | having |
8 | order by |
9 | desc |
10 | asc |
11 | join |
12 | inner join |
13 | left join |
14 | outer join |
15 | distinct |
16 | union |
17 | union all |
18 | intersect |
19 | except |
20 | offset |
21 | limit |
22 | fetch |
23 | top |
24 | like |
25 | current_date |
26 | now() |
27 | extract |
28 | second |
29 | minute |
30 | hour |
31 | day |
32 | week |
33 | month |
34 | quarter |
35 | year |
36 | decade |
37 | century |
38 | ::date |
39 | ::timestamp |
40 | ::text |
41 | ::integer |
42 | ::interval |
43 | upper |
44 | lower |
45 | format |
46 | nullif |
47 | coalesce |
48 | information_schema |
49 | table_name |
50 | table_schema |
51 | length |
52 | count() |
53 | sum() |
54 | min() |
55 | max() |
56 | avg() |
57 | round |
58 | random |
59 | generate_series(1, 10) |
60 | as |
61 | row_number() |
62 | rank() |
63 | dense_rank() |
64 | case when then end |
65 | and |
66 | or |
67 | in |
68 | on |
69 | + interval '1 day' |
70 | - interval '3 hour' |
71 | + interval '6 month' |
72 | cast |
73 | lpad |
74 | between |
75 | to_char |
76 | ::numeric |
77 | current_time |
78 | current_timestamp |
79 | date |
80 | datetime |
81 | false |
82 | fields |
83 | file |
84 | filter |
85 | first |
86 | float |
87 | ilike |
88 | interval |
89 | isnull |
90 | not |
91 | null |
92 | regexp_replace |
93 | rollup |
94 | schema |
95 | schema_name |
96 | table |
97 | timestamp |
98 | true |
99 | varchar |
100 | window |
Комментарии