´úÂëÊÇ rs = st.executeQuery("select top "+pageSize+" *from users where userId not in (select top "+pageSize*(pageNow-1)+" userId from users) ");´íÎóÌù³öÀ´É¹É¹°¡¡£»¹ÓÐÄãÓõÄÊý¾Ý¿âÊÇʲôÊý¾Ý¿â°¡£¬Ó¦¸ÃÊÇOracleµÄ°É *from ÖмäûÓпոñ ÊÇ°¡£¬ÄãµÃ°Ñ¾ßÌå´íÎóÌù³öÀ´¿´ÏÂ,»¹ÓÐÓõÄÊÇʲôÊý¾Ý¿â°¡¡£
* from ni de ÊÇʲôÊý¾Ý·°¡ *from ÖмäûÓпոñ
right
......³öÀàËƵĴíÎó¿ÉÒÔ°ÑÉú³ÉµÄÓï¾ä·Åµ½²éѯ·ÖÎöÆ÷Àï Ëû»áºÜÃ÷È·µÄ¸æËßÄãÊÇÄÄÀï³öÁË´íÎó Ҫѧ»á×Ô¼º·ÖÎöÎÊÌâ show sql ;¿´´íÎó, *from ÖмäûÓпոñºÃÏñÒ²ÄÜÔËÐÐ, ÎÒ˵´ó¸çÃÇ ËûÓõÄÊÇsql server Êý¾Ý¿â°Í
YES
1.´òÓ¡ÄãµÄsql Óï¾ä£¬ÔÚ³ÌÐòÖÐ.. 2.*from ÎÒÔÚoracleÉϲâÊÔ,ÊÇ¿ÉÒÔ²éѯµÄ... sqlÓï¾äÔÚ³ÌÐòÖÐдʱҪעÒâ¿Õ¸ñ£¬»¹ÓÐÈç¹ûÓÐ×Ö·ûÐÎʽµÄ²»ÒªÍüÁ˼Ó'' * from topÊÇ×ֶΰɣ¬select top ÁË»¹ * £¿ ²¹³äÒ»¾ä£¬°Ñ´íÎóÌù³öÀ´°¡