PgSql查询样例

-- 查询条数
(select * from snucs.biz_collect_record where trade_source = '003' and prod_code ='RXF' and collection_time > '2021-01-01 00:00:00' and collection_time < '2021-07-31 23:59:59'
and id < 1110636 order by id desc limit 2)
union all
(select * from snucs.biz_collect_record where trade_source = '003' and prod_code ='XJZCB' and collection_time < '2021-07-31 23:59:59'
and id < 1110636 order by id desc limit 2)
order by id desc limit 4

-- 查询最大id
(select max(id) id from snucs.biz_collect_record where trade_source = '003' and prod_code ='RXF' and collection_time > '2021-01-01 00:00:00' and collection_time < '2021-07-31 23:59:59')
union all
(select max(id) id from snucs.biz_collect_record where trade_source = '003' and prod_code ='XJZCB' and collection_time < '2021-07-31 23:59:59')
order by id desc limit 1;