Question about SUM and GROUP BY

Quote:

---

Originally Posted by topgun

try using this = hope it helps....

select a.state , a.city, sum(a.tot_amt)
from state_city_sales a
group by a.state , a.city

---

Back to square one................. :D ........... :p