A:  
SELECT
    D.*
FROM
    D
    INNER JOIN
(
    SELECT
        MOVIE
        ,   MAX(VISITS) AS VISITS
    FROM D
    GROUP BY MOVIE) F ON D.MOVIE = F.MOVIE AND D.VISITS = F.VISITS
rdkleine  2010-08-03 10:55:20

related questions

How do I include empty rows in a single GROUP BY DAY(date_field) SQL query?
Complex join with nested group-by/having clause?
Using Linqdatasource and groupby property
How can I read LINQ group by Query?
SQL "group by" question - I can't select every column
Table Group By - Tsql -
MySQL - Control which row is returned by a group by.
Optmizing MySQL GROUP BY or DISTINCT on large views
How to get list of values in GROUP_BY clause?
SQL select nth member of group
How to lambda the group by data on a LINQ to Sql results?
MSSQL: Only last entry in GROUP BY
MySQL Query - getting missing records when using group-by
sql group by versus distinct
Grouping List by the last Char
Why does SQL force me to repeat all non-aggregated fields from my SELECT clause in my GROUP BY clause?
SQL group by date, but get dates w/o records too
MySQL finding subtotals
SQL expression problem
C# List<> GroupBy 2 Values
How would I calculate timespans from a list of check in and check outs?
"Most popular" GROUP BY in LINQ?
How do I return my records grouped by NULL and NOT NULL?
How to concatenate strings of a string field in a PostgreSQL 'group by' query?
How do I use T-SQL Group By