Home -> Usenet -> comp.databases.oracle -> Re: How to get the first four rows???

         select x_date
           from (select x_date
                   from y_date)
          where rownum < 5
          order by x_date desc;