// offset is un-contained. eg: for 1 ~ 10 offset 2 rows fetch first 5 rows only while return 3 ~ 7 OFFSET %d ROWS FETCH FIRST %d ROWS ONLY // 针对Oracle12,还可以用下面这种形式。建议用上面这种standard OFFSET %d ROWS FETCH NEXT %d ROWS ONLY
offset 2 rows fetch first 5 rows only
Your email address will not be published. Required fields are marked *
Comment * </p><p class="comment-form-author"><label for="author">Name <span class="required">*</span></label> <input id="author" name="author" type="text" value="" size="30" maxlength="245" autocomplete="name" required=""/></p> <p class="comment-form-email"><label for="email">Email <span class="required">*</span></label> <input id="email" name="email" type="email" value="" size="30" maxlength="100" aria-describedby="email-notes" autocomplete="email" required=""/></p> <p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" type="url" value="" size="30" maxlength="200" autocomplete="url"/></p> <p class="comment-form-cookies-consent"><input id="wp-comment-cookies-consent" name="wp-comment-cookies-consent" type="checkbox" value="yes"/> <label for="wp-comment-cookies-consent">Save my name, email, and website in this browser for the next time I comment.</label></p>