I use MySQL, and as I said, I wasn't sure if it was standard Use whatever tickles your DB, the concept is what is important
Luc Foisy Java software development | Database development | Not an author of a book (but I do know NASA switch from Oracle to MySQL) :) > -----Original Message----- > From: David Gallardo [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 5:38 PM > To: JDJList > Subject: [jdjlist] RE: Performance Issues > > > What RDMS have you been smoking?<g/> > > I think LIMIT is SQL Server specific. Not standard SQL and > not supported on > Oracle. > > @D > > At 11:04 AM 11/21/2002 -0500, Luc Foisy wrote: > > >If you can't figure out what you need to do with that course > of action... > >If you are querying a database, you could use a LIMIT clause > > > >You can use the LIMIT to select a range of data to be > collected with your > >query ( at least I think thats pretty standard SQL, not sure though). > > [...] > > > David Gallardo | Software consultant | Author > C/C++ and Java software development | Database development | > Internationalization > Author of "Java Oracle Database Development," Prentice-Hall, > forthcoming > Dec. 2002 > > > ____________________________________________________ > To change your JDJList options, please visit: > http://www.sys-con.com/java/list.cfm > > Be respectful! Clean up your posts before replying > ____________________________________________________ > ____________________________________________________ To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm Be respectful! Clean up your posts before replying ____________________________________________________
