Skip to Content
0
Dec 05, 2013 at 06:24 AM

Eliminating duplicate entry

399 Views

0down votefavorite

Dear Experts,

I have a sample query below:

SELECT sites.siteName, value.siteIP, history.date FROM sites left JOIN history ON sites.siteName = history.siteName

left join value on value.sitename = sites.sitename ORDER BY siteName,date

First part of the output:

enter image description here

How can I remove the duplicates in siteName and siteIP columns but the row # is still from 1 to 10 ?

Pls advice. Thank you very much

Steve