Duplicate Data from Database

[Brachole]

I'm not sure this could be done, but is there a way of avoiding to display duplicate from a database?

Here's my application:

I am displaying a list of the different companies and the serial number of their equipment. Problem is, some of the Serial Numbers appear twice in the DB, which is totally normal (we keep of history of the repair history).

But I want to display the list withouts seeing the same Serial Number more than once. Is that possible?

Language: ASP (Javascript)
Database: MS Access
Dynamic Value: <%=(rsCompanies.Fields.Item("SerialNumber").Value)%>

[lmf232s]

Try this

SELECT DISTINCT Company, Equipment
FROM TABLE_NAME