Access answer.
Re: How do i select the most rented movie in a movierentals table in access?
SELECT TOP 1 MovieRentals.Movie
FROM MovieRentals
GROUP BY MovieRentals.Movie
ORDER BY Count(*) DESC;
MovieRentals table has id, movie, rentedDate as it's 3 fields and there is one row per movie rental. The only issue with this is that Access brings back multiple records if there is a tie.
|