> The query as shown does't actually have an ORDER BY clause in it;> did you write GROUP BY where you meant ORDER BY?
Thank you for your reply. I tried all combinations- GROUP BY- ORDER BY- GROUP BY & ORDER BYthe result is always the same.