从网上找了好久找到的,mark select * from t1 a where not exists (select 1 from t1 where a.p=p and a.q=q and a.id<id)