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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
