DB2 sorting page summary

First, SELECT * FROM (SELECT row_number () OVER () AS rown, CC_BRAND. * FROM CC_BRAND order by CC_BRAND.BRAND_CODE) as awhere. ROWN> = 1 AND. ROWN <= 10; my idea is as follows: I regard the running results marked in red in the first paging SQL statement as a result view. Then select and query the ROWN field in it. I feel that there is no task problem, but the result is wrong. I am puzzled when I run the red annotation part. The operation is completely correct, but all the operations are incorrect and the sorting is disordered. It is totally different from the sorting result of the red annotation part, finally, we searched for the "Sort distribution" example on the Internet and modified it. -www.2cto.com-AS follows: SELECT * FROM (SELECT row_number () OVER (order by CC_BRAND.BRAND_CODE) AS rown, CC_BRAND. * FROM CC_BRAND) as awhere. ROWN> = 1 AND. ROWN <= 10; the Blue annotation is different. You need to put the order in the brackets after over to sort the pages correctly. Author jvortex