Answer to Question #329788 in Databases | SQL | Oracle | MS Access for Suresh

Question #329788

Get the distinct ids of videos that belong to the following genres.



genre_id genre


201 Comedy


202 Action


203 Thriller


211 Scifi


Note:


Sort the output in the descending order ofvideo_id




Expected Output Format



video_id




Please help

1
Expert's answer
2022-04-19T03:08:19-0400
SELECT distinct video_id FROM video
where genre_id IN
(
201,
202,
203,
211
)
order by video_id desc;

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS