老问题请问honk大大和各位高手！

luobutou

下面的SQL按照honk大大交的方法可以运行了，但是为什么我加上rownum<一个值后就会报值太多无法显示呢？没加限制的时候都没问题啊。
SELECT name FROM Venues WHERE (name) IN
(SELECT /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID,feature,elong_lohoo_card,note,DIRECTIONS,parentvenueid,venuetype,2 FROM
       (select  /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID,feature,elong_lohoo_card,note,DIRECTIONS,parentvenueid,venuetype,2
       from Venues
       where ( Venues.City = '北京'
       and   branchvenue=0
       and   status=3
       and   ((sysdate-end_date)<2))
       order by VenueID desc
minus
SELECT /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID,feature,note,DIRECTIONS,parentvenueid,venuetype,2 FROM
      ( select /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID,feature,note,DIRECTIONS,parentvenueid,venuetype,2
      from Venues
      where ( Venues.City = '北京'
      and   branchvenue=0
      and   status=3
      and   ((sysdate-end_date)<2))
      order by VenueID desc )