Hafiz Abdullah Hafiz Abdullah - 5 months ago 13
SQL Question

Check database for similar value , MySQL

I have a table server like this;

Model | Brand
-------------------
M4000 | Dell
S4000 | Hp
S3500 | Hp
S6500 | Sun


I want to display different data from the 'Brand' field which means I don't want the second 'Hp' data to display again. How do I do that?

Answer
SELECT DISTINCT Brand FROM tableName
Comments