摘要:
---分页方法 ------------1.top分页:selecttop10*fromOrdersawherea.orderidnotin(selecttop10orderidfromOrdersorderbyorderid)orderbya.orderid------------2.MAX函数---这种方法的前提是有唯一值的一个列。selecttop10*fromOrdersawherea.orderid>(selectMAX(orderid)from(selecttop10orderidfromOrdersorderbyorderid)asorderid)orderbyorderi 阅读全文