selecting a single record from same multiple rows from single table : I have table
<pre>
ID     companyName     companyAddress     brandId<br/>
1      Mian and sons    154 C              1<br/>
2      Mian and sons    154 C              2<br/>
3      Mian and sons    154 C              3<br/></pre>

and i get only one of three
for example

query = "select companyName from Company"; i using this query

<pre>companyName
Mian and sons </pre>      