有时候关联查询并不需要太多子表数据 例如 我们只需要关联查询出两条代码如下 (select * from ( SELECT b.*, ROW_NUMBER() OVER ( PARTITION BY spe_id ORDER BY spe_id ) AS Seq FROM STO_SPE_RL as b) a WHERE a.Seq < 3 )