Which SQL keyword would be used to select all records except those with a Per field value

Question:

Which SQL keyword would be used to select all records except those with a Per field value of Hour?

a. WHERE NOT Per = 'Hour'

b. WHERE Per = 'Hour'

c. SELECT NOT Per = 'Hour'

d. SELECT * EXCEPT 'Hour'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: