CODEWITHSUNDEEP
mysql
Murtdha Dakhil
Murtdha Dakhil

Reputation: 25

get one value from many same value in same column php

I want to take only one value from these matches values in one column and put it in select

SELECT company FROM `main_fore` ORDER BY `fore_id`

Like this column in this picture

Upvotes: 1

Views: 147

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269773

Are you looking for select distinct or group by?

SELECT company
FROM main_fore 
GROUP BY company
ORDER BY MIN(fore_id)

Upvotes: 1

Related Questions