File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
fetch first in Oracle
Joined: Jul 17, 2002
Jan 19, 2004 04:21:00
Any one know how to do the following sql in Oracle?
select c1 from table1 order by c2 fetch first 1000 rows only
Joined: Apr 25, 2003
Jan 19, 2004 08:34:00
I believe you need to do:
SELECT .... WHERE ROWNUM > 0 AND ROWNUM < 1000 ORDER BY c2
It's been a while since I used Oracle, but I believe that's it.
An egg is a chicken's house!
I agree. Here's the link:
subject: fetch first in Oracle
Java API for Exchange Server
jdbc resultset to xml
Export ResultSet to pipe delimited file
JdbcOdbcDriver/Stored procedures. Please help
Getting the "Most Recent" Record via SQL
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013