- 博客(2)
- 收藏
- 关注
原创 2021-01-18
Hive 分页查询 select * from ( select row_number() over ( order by a.project_id) as rnum, a.* from ( select c.project_id, sum(d.fav_price) as fee, max(c.city) as city from
2021-01-18 12:06:43
74
原创 sql常用命令
@[TOCA](sql 常用命令) select * from ( select row_number() over (partition by a.user_id order by a.project_id) as rnum, count(1) over (partition by a.user_id) as rnum2, a.* from ( select c.user_id, c.project_id from henan841.wy_access_data_m c where c.
2021-01-18 12:01:02
109
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人