I used the rowcount function, dropped the dense_rank, and re-inserted the order by usage, and it works now.
Thanks to all! Rick On Fri, Sep 19, 2008 at 5:46 AM, Joe DeSouza <[EMAIL PROTECTED]> wrote: > ** > > Try using either the LIMIT or the TOP clause.. > > > > The usage of TOP if I am not mistaken is > > > > Select TOP n Column1, Column2,... from table_name order by Column[m] desc; > > since you want to order your output in a descending order on the column > that you choose.. > > > > The use of limit is something like > > Select Column1, Column2.... from table_name LIMIT 10 order by Column[m] > desc; > > If this doesn't work try > > Select Column1, Column2.... from table_name order by Column[m] desc LIMIT > 10; > > > > Hope this helps.. > > > > Joe > > ----- Original Message ---- > From: Rick Cook <[EMAIL PROTECTED]> > To: [email protected] > Sent: Thursday, September 18, 2008 8:35:49 PM > Subject: Ranking rows in Oracle > > ** Looking for some help in debugging my syntax - Remedy says I'm missing > a parameter, but not which one. > > What I want to do is take a table with 100+ rows, and only return the 10 > with the highest value in an integer field, ranked in descending order. > > Here's the syntax that's failing: > > SELECT Product_Categorization_Tier_1, Usage > (SELECT Product_Categorization_Tier_1, Usage dense_rank() over > (ORDER BY Usage desc) > FROM CIS_PCT_ProductCategoryUsage) > WHERE ((Company = '$1000000001$') OR (Company = '- Global -')) > AND (Help_Desk_Selection = 0) > AND ((Assigned_Group = '$1000000217$') OR (Assigned_Group IS NULL)) > AND (Status_PDA = 1) > > I'd appreciate some help on this one. > > Rick > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
