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;

---

懂得,原来世界如此简单!