17,075
社区成员
发帖
与我相关
我的任务
分享
--不知道按照ggtype分组,再按照dt_broadcast降序排列能不能提高你是执行速度!
select *
from (select OBJUID,
XMMC,
dt_broadcast,
ggtype,
Row_Number() over( partition by ggtype order by dt_broadcast desc) rownum_
from (select OBJUID,
na_item_name XMMC,
dt_broadcast,
1 ggtype
from db_perambulate_item_broadcast t
union all
select OBJUID,
na_mine_name XMMC,
dt_broadcast,
2 ggtype
from db_mining_apply_broadcast t))
where rownum <7;