LEFT OUTER JOIN
(SELECT * FROM C02 WHERE ROWNUM < 3 AND 产品ID =C01.产品ID ORDER BY 包装ID) T ON T.产品ID = C01.产品ID (SELECT * FROM
阅读背景：
求问怎么查询子表的前两行数据，rownum<3
来源：互联网
LEFT OUTER JOIN
(SELECT * FROM C02 WHERE ROWNUM < 3 AND 产品ID =C01.产品ID ORDER BY 包装ID) T ON T.产品ID = C01.产品ID (SELECT * FROM
分享到：
