Nadine1的专栏

<br /><br /> <br />--所以要查询Test表第n条到第m条的记录，我们应该这样写：<br />--对已形成的rownum进行过滤<br />select * from (<br />  --    先用一个select把待查sql包围起来，此时rownum已经形成<br />       select row_.*, rownum rownum_ from ( select * from test  ) row_<br />) where rownum_ <= m and rownum_

<br /><br />SELECT  bid  FROM   test1<br />where pid in (select fid from test2 m where m.date between sysdate-1 and sysdate)    ---当天日期内的记录<br />GROUP   BY   bid ---去掉重复记录