Given an SQL table ‘Books’ with fields Title, Author, and Genre, which query would return a list of unique Genre values?

Given an SQL table ‘Books’ with fields Title, Author, and Genre, which query would return a list of unique Genre values?
A . SELECT Genre FROM Books;
B . SELECT SET Genre FROM Books;
C . SELECT UNIQUE Genre FROM Books;
D . SELECT DISTINCT Genre FROM Books;

Answer: D

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments