Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: select ... from (select ... from ... order by ...) doesn't work ?

Re: select ... from (select ... from ... order by ...) doesn't work ?

From: Miodrag Prizmiæ <infoprojekt_at_ri.tel.hr>
Date: Wed, 15 Sep 1999 15:02:20 +0200
Message-ID: <7ro5co$b8l$1@as102.tel.hr> 





> select * from


> (select column from table order by column)


> where rownum <=50


>


> Anybody has any ideas ?


>




select * from


(select column from table group by column,rowid)
where rownum <=50


Received on Wed Sep 15 1999 - 08:02:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US