{"id":1075,"date":"2020-09-09T10:45:08","date_gmt":"2020-09-09T02:45:08","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=1075"},"modified":"2020-09-09T10:45:09","modified_gmt":"2020-09-09T02:45:09","slug":"gbase-8a-%e9%80%9a%e8%bf%87first_rows%e7%9a%84hint%e6%8f%90%e9%ab%98%e5%b8%a6limit%e7%9a%84%e7%ae%80%e5%8d%95%e6%9f%a5%e8%af%a2%e6%80%a7%e8%83%bd","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/1075","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a \u901a\u8fc7first_rows\u7684hint\u63d0\u9ad8\u5e26limit\u7684\u7b80\u5355\u67e5\u8be2\u6027\u80fd"},"content":{"rendered":"

GBase 8a \u6570\u636e\u5e93\u96c6\u7fa4\uff0c\u5728\u6267\u884c\u6700\u7b80\u5355\u7684 select where limit \u65f6\uff0c\u4e0d\u5305\u542border, group\u7b49\u590d\u6742\u64cd\u4f5c\u3002GBase \u901a\u8fc7first_rows\u7684hint,\u5728\u7cfb\u7edf\u8d44\u6e90\u6d6a\u8d39\u548c\u6027\u80fd\u4e4b\u95f4\u53d6\u5f97\u4e00\u5b9a\u7684\u5e73\u8861\u3002<\/p>\n\n\n\n

\u8fd9\u79cd\u6700\u7b80\u5355\u7684\u67e5\u8be2\uff0c\u6bd4\u5982\u67e5\u8be2\u67d0\u4e2aIP\u7684\u4e0a\u7f51\u8bb0\u5f55\u524d100\u884c\uff0c\u67092\u79cd\u6267\u884c\u65b9\u6848\uff1a<\/p>\n\n\n\n

select * from t_autoinc where id<200 limit 100;<\/code><\/pre>\n\n\n\n
1\u3001\u662f\u5c06\u547d\u4ee4\u4e0b\u53d1\u5230\u6bcf\u4e2a\u6570\u636e\u8282\u70b9\uff0c\u5e76\u8fd4\u56delimit\u8981\u6c42\u7684\u884c\u6570\uff0c\u7136\u540e\u96c6\u7fa4\u518d\u4ece\u6240\u6709\u7ed3\u679c\u79cd\u9009\u62e9\u9700\u8981\u7684\u884c\u6570\u8fd4\u56de\u3002<\/p>\n\n\n\n
2\u3001\u662f\u6328\u4e2a\u8282\u70b9\u67e5\u8be2\uff0c\u5982\u679c\u4e0d\u6ee1\u8db3\u5219\u67e5\u8be2\u4e0b\u4e00\u4e2a\u8282\u70b9\u3002<\/p>\n\n\n\n
\u5176\u4e2d\u65b9\u68481\uff0c\u5728\u8282\u70b9\u5f88\u591a\u65f6\uff0c\u6bd4\u598210\u4e2a\uff0c\u4f1a\u9020\u6210\u5b9e\u9645\u8fd4\u56de\u7684\u7ed3\u679c\u884c\u6570\u4e3a10\u4e2a*100\u884c=1\u4e07\u884c\uff0c\u5bf9\u6574\u4f53\u8d44\u6e90\u6765\u8bf4\u5c31\u662f\u4e2a\u6d6a\u8d39\u3002
\u65b9\u68482\u907f\u514d\u4e86\u8fd9\u4e2a\u95ee\u9898\uff0c\u4f46\u4f1a\u9047\u5230\u67d0\u4e9b\u6781\u7aef\u60c5\u51b5\uff0c\u6bd4\u5982\u524d\u9762\u6240\u6709\u7684\u8282\u70b9\u884c\u6570\u90fd\u4e0d\u6ee1\u8db3100\u884c\uff0c\u6700\u7ec8\u5c31\u662f\u6570\u636e\u5e93\u3010\u4e32\u884c\u3011\u67e5\u8be2\u4e8610\u4e2a\u8282\u70b9\uff0c\u6700\u7ec8\u6574\u4f53\u6027\u80fd\u5c31\u662f\u6bcf\u4e2a\u8282\u70b9\u6027\u80fd\u768410\u500d\u3002<\/p>\n\n\n\n
\u800cfirst_row\u8fd9\u4e2ahint,\u53ef\u4ee5\u5728\u4e2d\u95f4\u7531\u7528\u6237\u6307\u5b9a\u5e73\u8861\u7684\u7b56\u7565\u3002\u6bd4\u5982 <\/p>\n\n\n\n
select \/*+first_rows(10)*\/ * from t_autoinc where id<200 limit 100;<\/code><\/pre>\n\n\n\n
first_row(10) \u5219\u4f1a\u8ba9\u6240\u6709\u8282\u70b9\u90fd\u53c2\u4e0e\u67e5\u8be2\uff0c\u4f46\u65e0\u9700\u5230100\u884c\uff0c\u800c\u662f10\u884c\u5c31\u8fd4\u56de\u8c03\u7528\u65b9\uff0c\u7136\u540e\u7ee7\u7eed\u67e5\u8be2\u4e0b\u4e00\u6279\u3002\u800c\u8d1f\u8d23\u6536\u96c6\u7684\u7ba1\u7406\u8282\u70b9\uff0c\u53d1\u73b0\u5404\u4e2a\u8282\u70b9\u53d1\u6765\u7684\u603b\u884c\u6570\u5df2\u7ecf\u8fbe\u5230\u8981\u6c42\u662f\uff0c\u4f1a\u4e3b\u52a8\u5173\u95ed\u5404\u4e2a\u8282\u70b9\u7684\u8fde\u63a5\uff0c\u907f\u514d\u540e\u7eed\u6d6a\u8d39\u8d44\u6e90\u3002<\/p>\n\n\n\n
\n
Directory Navigation<\/p>\n