Was responding to James's comment: "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."
That's why I started the message with slightly off-topic Axton Serouche Rahimpour wrote: > hi, > > just to be sure I understand the concern correctly: > in the Advanced Search bar you type something like "select <columns> > from <table> where <conditions> and/or <chunks>" ? > Or was Angus just refering to the use of the relational operators ? > Because I am not sure whether we could use select top ... or select ... > rownum. Could we ? > Thanks lightening the dark. > Serouche > > > > Axton Grams wrote: > >> 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 >> >> >> > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
