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: Help! In Oracle, is there a function that will act like the "Top" function in MSSQL?

Re: Help! In Oracle, is there a function that will act like the "Top" function in MSSQL?

From: tiny anklet bells <nroshak_at_hcs.harvard.edu>
Date: 26 Jan 2000 00:45:25 GMT
Message-ID: <86lg35$khk$3@news.fas.harvard.edu> 





What does the "Top" function do?



If you're trying to select just the top few rows of a table (?), you can
do "select * from tablename where rownum < 10" -- no idea if this is what
you're looking for, though.



Natalka



Zorg Jillson Holyfield hath momely rade gribble: 


: Hi,





: I am new to Oracle and was wondering if there is a function that will act


: like the "Top" function in MS SQL 7. Any info. would be greatly appreciated.


: Thanks.





: Jillson



Received on Tue Jan 25 2000 - 18:45:25 CST












Original text of this message













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