With Sql How Do You Select All Fields From 8220customers8221 #53
With SQL, how do you select all fields from “Customers” table whose country is NOT “Germany” and NOT “USA”?
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 SQL Clause, Operators and Keywords - SQL And, Or, Not - Quiz No.1.
With SQL, how do you select all fields from “Customers” table whose country is NOT “Germany” and NOT “USA”?
Select * from Customers where not country=’Germany’ and country=’USA’;
Select * from Customers where not country=’USA’ and country=’Germany’;
Select * from Customers where not(country=’USA’ and country=’Germany’);
Select * from Customers where not(country=’USA’ or country=’Germany’);
