What SQL statement lists all the fields from the records in the TaskMasterList table with a CategoryID

Question:

What SQL statement lists all the fields from the records in the TaskMasterList table with a CategoryID of Database?

a. SELECT *

FROM TaskMasterList;

b. SELECT *

FROM TaskMasterList WHERE Count(*) > 1;

c. SELECT *

FROM TaskMasterList WHERE CategoryID = 'Database';

d. SELECT CategoryID FROM TaskMasterList WHERE CategoryID = 'Database';ProjectID ProjectStartDate ClientID EmployeelD 06-Feb-19 1 1 2 3 4 7 9 10 11 13 14 15 16 17 18 19 20 222 21

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: