T tanjch Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-31 #1 比如在oracle中可以这样:select * from table where rownum<100 就只返回100个row
Y yaya8163 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-31 #2 select top 100 * from table
Z zm30 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-31 #3 set rowcount 100 select * from table