名称 | 语法 | 使用 |
---|---|---|
select | ||
where | ||
order by | ||
fetch | ||
limit | ||
offset | ||
distinct | ||
列别名 | ||
表别名 | ||
in | ||
betwenn | ||
like | ||
is null | ||
exists | ||
all | ||
any | ||
group by | ||
having | ||
grouping sets | ||
rollup | ||
cube | ||
join | ||
子查询 | ||
cte | ||
union | ||
intersect | ||
except | ||
insert on conflict | ||
update | ||
update...from | ||
delete | ||
清空表 | ||
case |