Slightly off-topic, but for sql statements... SQL Server: select top 100 a,b,c from x where y = z
Oracle: select a,b,c from x where y = z having rownum < 100 Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: > ** > Angus: > > Please accept my apologies as I remember it being there. I just checked > again and could not find it. This is sad. > > However, it is possible to use the User Preferences form to set this > value for a particular user. Otherwise, you would have to set this > value for the entire server. I don't think it is possible to set a > limit to the number of returned items in an SQL statement other than > careful selection of the WHERE portion of the SELECT statement. > > James McKenzie > > > ------------------------------------------------------------------------ > *From:* Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] *On Behalf Of *Angus Comber > *Sent:* Thursday, July 06, 2006 1:33 PM > *To:* [email protected] > *Subject:* Re: Can you restrict searches to eg TOP 100 - like in SQL? > > ** > There does not appear to be a way to restrict number of records returned > in the user tool. > > Angus > > > ----- Original Message ----- > *From:* McKenzie, James J C-E LCMC HQISEC/L3 > <mailto:[EMAIL PROTECTED]> > *Newsgroups:* public.remedy.arsystem.general > *To:* [email protected] <mailto:[email protected]> > *Sent:* Thursday, July 06, 2006 8:53 PM > *Subject:* Re: Can you restrict searches to eg TOP 100 - like in SQL? > > ** > > Agnus: > > Yes. Check out the advanced tab for user options. If you want to > do this at the database level, I don't know of a method to do this > other than a really refined query. > > James McKenzie > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Angus Comber > Sent: Thursday, July 06, 2006 12:50 PM > To: [email protected] > Subject: Can you restrict searches to eg TOP 100 - like in SQL? > > If I go into user tool and do an advanced search I can use SQL type > syntax. > But is there any means of restricting the number of records > returned. Eg the first 100? > > Angus > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > __20060125_______________________This posting was submitted with > HTML in it___ > > __20060125_______________________This posting was submitted with HTML in > it___ __20060125_______________________This posting was submitted with > HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
