| 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 |
Комментарии