ORACLE返回9行:
select * from po.po_headers_all where rownum <=9;
MYSQL返回9行:
select * from po.po_headers_all LIMIT 9;
SQL SERVER 返回9行:
select TOP 9 * from po.po_headers_all
區別在加?煮w部分。
[@more@]ORACLE返回9行:
select * from po.po_headers_all where rownum <=9;
MYSQL返回9行:
select * from po.po_headers_all LIMIT 9;
SQL SERVER 返回9行:
select TOP 9 * from po.po_headers_all
區別在加?煮w部分。
[@more@]