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:
Good Luck, Avi.
Joined: Oct 06, 2007
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 ]