Originally posted by abhaysk
Jurij :
Thnaks....but again why will the query with "having option before group by clause" will not work???

Abhay.
Abhay,
HAVING clause is used with GROUP BY clause and in the syntex it should be after GROUP BY.