This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Prashanth, If I remember correctly, Oracle only allows less than or equal to logical operators with rownum pseudo-column. Hence your query using greater than operator does not work. I'm only guessing, but I think you may be able to use the "between" operator, as in:
This is your original query (see the comments next to your code):
Run the following:
to find the total number of rows associated with the ID group by clause... but as written... you are always showing the numbers for all your rows grouped by ID. [ October 30, 2008: Message edited by: Paul Campbell ]
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Values not retireved using rownum in oracle