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

Question

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

Answer 1

SELECT distinct video_id FROM video
where genre_id IN
(
201,
202,
203,
211
)
order by video_id desc;