Painful me, asking a rookie question, a question about SQL statements

qxqx_me

I have a data sheet about video on demand

I want to sort in descending order by click-through rate, movie names don't show duplicate names
CTR field is FClick
Movie name field is FName
The name of the data table is: Film

I wrote this: select top 3 FName, FClick From Film by Group FName order By FClick DESC

An error occurred while configuring SQL in the data adapter of the VS.NET environment, please help

weh007

select top 3 FName, FClick From Film Group by FName order By FClick DESC
The previous by and group swap

苹果小刀

SELECT DISTINCT TOP (3) FName, FClick
FROM Film
GROUP BY FName
ORDER BY FClick DESC

qxqx_me

Thank youweh007and苹果小刀