SQL

Pataasin ang iyong marka sa homework at exams ngayon gamit ang 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;


Kaugnay na mga set ng pag-aaral

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