SQL 代码规范-- Good
select user_id, count(*) as total_charges
from charges
group by user_id
-- Good
select user_id, count(*) as total_charges
from charges
group by 1
-- Bad
select
timestamp_trunc(created_at, month) as signup_month,
vertical,
count(*) as users_count
from users
group by 1, vertical
粤ICP备18099781号-6
|
粤公网安备 44030502004330号
|
违法和不良信息举报
由 Summer 设计和编码 ❤
请登录
关于 LearnKu