This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan 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 ]