postgres 查询跳过第一笔记录,只查询一笔记录

select name,partner_number,* from res_partner
where name in ( select name from tb_repeat_partner)
ORDER BY "name","id"
limit 1
OFFSET 1;

posted @ 2020-05-19 18:45  那时一个人  阅读(409)  评论(0编辑  收藏  举报