type
status
date
slug
summary
tags
category
icon
password
Introducing queries
Writing queries
Aliasing
Distinct records
VIEWS
SQL flavours
POSTGRE SQL
SQL SERVER
COUNT()
DISTINCT
WHERE
multiple criteria
OR AND BETWEEN
LIKE
used to search for a pattern in a field
% match zero, one, or many characters
_ match one character
NOT LIKE
WHERE … IN
NULL
missing value
SUMMARIZING DATA
aggregate functions
avg(), sum(), min(), max(), count()
ROUND()
- 作者:Mingyu Peng
- 链接:https://pengmingyu.xyz/article/37ed50f9-3283-4ce4-b26e-9558e55d58f9
- 声明:本文采用 CC BY-NC-SA 4.0 许可协议，转载请注明出处。
