2010/06/09

HAVING

SELECT Sum(qty),itm_id FROM table_name GROUP BY itm_id HAVING SUM(qty) >= 6000000;

No comments:

Post a Comment