SQL Database code

Question

The question is to Produce a list of the top 3 most popular movies for a given genre for the current month.

How to find the top 3 most popular movies??

select DVD.Genre, DVD.MovieTitle, BorrowDVD.Ratings
from DVD join BorrowDVD
    ON DVD.DVDID = BorrowDVD.DVDID
WHERE DVD.Genre = Animation

please add some sample table data and the expected result - as well in formatted text. — TheGameiswar
– TheGameiswar, Commented Mar 17, 2017 at 9:08
what is the error? Can paste the table structure of DVD and BorrowDVD table please.... — ProgrammerBoy
– ProgrammerBoy, Commented Mar 17, 2017 at 9:37
Please read meta.stackoverflow.com/questions/285551/… and the accepted answer — user330315
– user330315, Commented Mar 17, 2017 at 11:23

BeanFrog · Accepted Answer · 2017-03-17 11:27:46Z

1

Put single quotes around the word animation:

WHERE DVD.Genre = 'Animation'

SQL thinks Animation is a column, putting quotes around it shows that it is a string to match.

answered Mar 17, 2017 at 11:27

BeanFrog

2,32514 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mansoor · Accepted Answer · 2017-03-17 09:14:12Z

0

Use ROW_NUMBER method and get top 3 most popular movies :

SELECT *
FROM 
(
    SELECT * ,  ROW_NUMBER() OVER(PARTITION BY Movie_type) RNo
    FROM your_tablename
) WHERE RNo <= 3 -- AND your_another WHERE conditions.

edited Mar 17, 2017 at 9:14

answered Mar 17, 2017 at 9:11

Mansoor

4,1921 gold badge19 silver badges27 bronze badges

Collectives™ on Stack Overflow

SQL Database code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related