[SOLVED] trouble using distinct

[Lijoyx]

hello friends,

 

i have to fetch all the 3 colums from a table using a 'FID' . i need the 'FID' to be distinct.

FID repeats in the table

 

i used this query

 

SELECT DISTINCT FID,FNAME, FVALS

FROM `table1`

 

but it filters all the three colums.

 

is there any way to achieve my task?

 

[Lijoyx]

someone please tell me if this question isn't clear

[dilum]

Try this,

 

SELECT DISTINCT FID,FNAME, FVALS

FROM `table1`GROUP BY FID

[Lijoyx]

thank you dilum

that works