I want to TOP the results of querystrings for a page. my results look like: -------- 20% coolpage.html 0.2% coolpage.html?aljdhlksjdhalk=whatever&jdkajsdg=ID5629876 0.2% coolpage.html?alksjddasasda=whatever&jdkajsdg=ID2083723 0.1% coolpage.html?dqdhksjbjhgk=whatever&jdkajsdg=ID2983746 0.1% coolpage.html?jdhaldkshqgwi=whatever&jdkajsdg=ID679506 0.1% coolpage.html?aljdhalksjdhalk=whatever&jdkajsdg=ID123123 17% dullpage.html 0.2% dullpage.html?aljdhlksjdhalk=whatever&jdkajsdg=ID5629876 0.2% dullpage.html?alksjddasasda=whatever&jdkajsdg=ID2083723 -------- I really only want to show the top3 of most requested pages/querystrings. Isn't there a TOP function or whatever? Or can I use a variant of the FLOOR command? Can I sort the results without grouping the pages.
cheers P +------------------------------------------------------------------------ | TO UNSUBSCRIBE from this list: | http://lists.meer.net/mailman/listinfo/analog-help | | Usenet version: news://news.gmane.org/gmane.comp.web.analog.general | List archives: http://www.analog.cx/docs/mailing.html#listarchives +------------------------------------------------------------------------
