Answer to Question #169736 in Databases | SQL | Oracle | MS Access for srikanth

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 of
video_id
Expected Output Format
video_id
...
genre_id genre_type
201       ACTION 
202       COMEDY
203       THRILLER
204       ROMANTIC
205        TECHNICAL
206       HEALTH CARE
207       GAMING
208       MUSIC VIDEOS
209       TEASER
210        INSPIRATIONAL
211       SCI-FI

Answer 1

SELECT distinct genre_id as video_id FROM quiz.video;

SELECT distinct genre_id as video_id FROM quiz.video order by genre_id desc;