Merge similar rows and sum their values?

This is my table:

URL           | Art | Design 
example1.com     1             
example1.com     1             
example1.com     1             
example1.com            1         
example2.com            1
example2.com            1

I want to merge columns with same URL and sum the values of Art and Design in the process, to get something li开发者_如何学JAVAke:

URL           | Art | Design
example1.com     3      1
example2.com            2

How is this done?

---

Use GROUP BY and SUM:

SELECT URL, SUM(Art) as Art, SUM(Design) AS Design
FROM yourtable
GROUP BY URL

---

select URL,sum(art),sum(design) From MYTABLE group by URl

---

select url,SUM(art),SUM(design) from  tab1 group by url

Where tab1 is your table name

---

Try this:

SELECT URL, COUNT(Art), COUNT(Design)
FROM myTable
GROUP BY URL

---

Have you tried anything till now?

It is as simple as:

select url, SUM(art) as Art, SUM(design) as Design from [MyTable] group by url