Patrick Patrick - 1 year ago 57
SQL Question

Retruning all values without duplicates in MySQL

Im trying to return all the possible values in a table, but without duplicate values.

SELECT * FROM optional_hardware;

Is there any other way I can return all values without duplicate values?

Answer Source

Use the DISTINCT keyword

SELECT DISTINCT column FROM optional_hardware;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download