SQL
bright_secret
这个作者很懒,什么都没留下…
展开
-
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 阅读 · 0 评论 -
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 阅读 · 0 评论