1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

How do i select the most rented movie in a movierentals table in access?

Discussion in 'SQL - Questions and Answers' started by Watson Kaunda, Jun 28, 2006.

  1. Watson Kaunda New Member

    Dialect: SQL 92
    Watson Kaunda, Jun 28, 2006
    #1

  2. Lori Sites Guest

    Dialect: 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.
    Lori Sites, Jul 19, 2006
    #2

Share This Page