select quiery problem

[batman007]

Table: Persons

P_Id | F_Id | LastName | FirstName
1 | 20 | Hansen | Timoteivn 10
2 | 21 | Svendson | Tove
3 | 21 | Svendson | Tove
4 | 22 | Petterse | Kari
5 | 23 | Sraveen | abbaraju

HI I want to select 'LastName' from table persons where 'LastName' starting with string 'S' and Distinct F_Id order by 'LastName'

[mwasif]

[CODE=mysql]SELECT LastName FROM Persons
WHERE LastName LIKE 'S%'
GROUP BY F_Id
ORDER BY LastName[/CODE]

[batman007]

Thank you very much friend

[mwasif]

You are welcome