Oracle SQL??????Ч??????????
???????????? ???????[ 2012/9/27 10:12:42 ] ????????
???????????????У?????????????????????в??????????????е?rowid??????rowid??????????????????
????????????У??????洢??????????λ??????????飬??????????????е??????ROWID????????SQL???в?????????????????飬??????????ROWID??????????????顣???????????????????顣
???????磺SELECT a??b??cFROM TEST_DB WHERE b=1
??????ò???????е?????????????????
????A????b????н???????
?????????b????н????????????????SQL???????????????????裬??????и???е?????顣???????????????????????й?????????????????????????????????????????飬???????
????B????b?????????
?????????b??????????????????и???SQL?????????????????裬???????????b=1?????λ?????????????3???????????????????е?ROWID????????ROWID???????????????????????????????????????????????????????????????????????b???????У?a???????????У??????????β??a?????a????????У?????????????
??????????????У??????????????????????????????????????????????????ROWID???????ROWID???л??????
??????????? SELECT * FROM ( SELECT ROW_NUMBER OVER (ORDER BY A ) RN??T.* FROM TABLE T WHERE B=? AND C=? ) WHERE RN>=1 AND RN <=20
??????÷?????????У????????B??C??A????????????????????????£?
????1???????????? SELECT * FROM TABLE T WHERE B=? AND C=??????踐??1000???????
????2??????????????1000???????ROWID???????????????????????????1000????????????????3????????У??????????6??????顣?????ROWID?????????????????????1000??????????1000????????У?????????1000?顣??????????????????????1006?顣
???????????????????д????
????SELECT * FROM TABLE T?? (SELECT RID FROM (SELECT ROWID RID?? ROW_NUMBER OVER(ORDER BY A) RN FROM TABLE WHERE B=? AND C=?) WHERE RN >1 AND RN<=20 ) TMP WHERE TMP.RID = T.ROWID
???????????У?????SELECT RID FROM (SELECT ROWID RID?? ROW_NUMBER OVER(ORDER BY A) RN FROM TABLE WHERE B=? AND C=?) WHERE RN >1 AND RN<=20????????????????л??????????????????????????6????顣?????????20??????????????20?е?ROWID???????????????????20?ж???20????????У????????????26??????顣
??????????Ч??????????????????????????????????SQL?????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11