|
||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
||||||
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread |
06-28-2006, 02:13 AM
|
|||
|
|||
SQL 92 dialect question:
How do i select the most rented movie in a movierentals table in access?    
|
|
07-18-2006, 11:11 PM
|
|||
|
|||
|
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. 
|
