SQL

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Select all records where the City column has the value 'Berlin' and the PostalCode column has the value 12209. ________ * FROM Customers _______ City = 'Berlin' ____ __________ = 12209;

SELECT * FROM Customers WHERE City = 'Berlin' AND PostalCode = 12209;

Select all records where the City column has the value 'Berlin' or 'London'. _______ * FROM Customers _______ City = 'Berlin' __ ____ = '________';

SELECT * FROM Customers WHERE City = 'Berlin' OR City = 'London';

Select all records where the City column has the value "Berlin". SELECT * FROM Customers ________ ________ = '_________';

SELECT * FROM Customers WHERE City = 'Berlin';

Select all records where the CustomerID column has the value 32. SELECT * FROM Customers ________ CustomerID __ ___;

SELECT * FROM Customers WHERE CustomerID = 32;

Use the NOT keyword to select all records where City is NOT "Berlin". SELECT * FROM Customers ____________ = '_______';

SELECT * FROM Customers WHERE NOT City = 'Berlin';

Insert the missing statement to get all the columns from the Customers table. _______ * FROM CUstomers;

SELECT * FROM Customers;

Write a statement that will select the City column from the Customers table. ______ ______ _______ Customers;

SELECT City FROM Customers;

Select all the different values from the Country column in the Customers table. _________ ________ Country FROM Customers;

SELECT DISTINCT Country FROM Customers;


Ensembles d'études connexes

Maternal & Child Health Nursing Chapter 8

View Set

Chapter 2: Medical-Surgical Nursing

View Set

Chapter 25 Alterations in Renal Function

View Set

CHEM: REDOX REACTIONS DYNAMIC MODULE

View Set

Mastering Microbiology Ch 8 --Bauman 5th Ed

View Set

Chapter 29: Autonomic Nervous System

View Set

Мысленные тренажёры. Визуальные образы.

View Set

HLHS211 - Nutrition Chapter 3 & 4 Review

View Set

Pathopharm Drugs for Viral Infections

View Set

CHAPTER 18 - PHYSICS - ELECTRIC CHARGE

View Set