FIRST_VALUE

select *
  from (select kk.nm_info_id,
               kk.st_info_title,
               tt.nm_attach_id,
               attach.st_attach_title
          from pb_information kk
          left join (select distinct (FIRST_VALUE(t.nm_info_attach_id)
                                     OVER(PARTITION BY i.nm_info_id ORDER BY
                                          t.dt_input desc)) as nm_attach_id,
                                    i.nm_info_id
                      from pb_info_attach t
                      left join pb_information i on i.nm_info_id = t.nm_info_id
                     where t.st_attach_type = '.jpg'
                       and i.st_is_handin = '3'
                       and i.st_del_flag = '0') tt on kk.nm_info_id = tt.nm_info_id
         inner join pb_info_attach attach on attach.nm_info_attach_id = tt.nm_attach_id
         order by kk.dt_deploy_date desc)
 where rownum <= 8

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值