This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori 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 ]