Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

24 cards

()

Section 1

Preview this deck

select FirstName, middlename, LastName, Title, Phone, EmailAddress from DimEmployee

Front

1 / 24

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (24)

Section 1

(24 cards)

select FirstName, middlename, LastName, Title, Phone, EmailAddress from DimEmployee

Front

Pull the first name, middle name, last name, title, phone number, email address from the "DimEmployee" table

Back

________ constraints results to unique values

Front

DISTINCT

Back

The ____ clause defines the table

Front

FROM

Back

A query to pull a given first name with a specified birthdate. Also uses the "AND" expression

Front

select firstname, lastname, birthdate from DimEmployee where FirstName = 'Kevin' and BirthDate > '1980'

Back

DELETE

Front

Removes one or more rows from a table ----------------------------------------------- DELETE FROM contacts WHERE id = 2

Back

The ______ list defines the columns

Front

SELECT

Back

UPDATE

Front

Modifies one or more rows in a tables ------------------------------------------ UPDATE contacts SET last_name='Ahern' WHERE id =1

Back

T/F: DISTINCT adheres to all of the entries in the select clause, not just the first one

Front

True

Back

select distinct D.firstname as FirstFirst, D.lastname as LastLast from DimEmployee D;

Front

Standard distinct Query, using qualified and aliased table names, with custom names using "AS"

Back

Query data with the ______ Command

Front

SELECT

Back

TF: The name of the table should be what each row is about

Front

True

Back

--

Front

Comment out

Back

T/F: A "FROM" clause is required when using a "SELECT" statement

Front

True

Back

Select and From

Front

Both a "Clause"

Back

Not a DISTINCT query.

Front

It returns ALL of the _______.

Back

A DISTINCT query.

Front

select distinct FirstName from DimEmployee --------------------------------------------------- EX: No two Similar names What are all of the different countries we sell to?

Back

SELECT first_name, last_name FROM contacts

Front

Please give me the first name and last name columns from the CONTACTS table

Back

AND

Front

Combines two expressions Both must be true

Back

T/F: DISTINCT is a qualifier

Front

True

Back

INSERT

Front

Adds one or more rows into a table ---------------------------------------------- INSERT INTO contacts (first_name, last_name) VALUES ('Fritz','Onion')

Back

"where"

Front

Clause

Back

Boolean operators

Front

Back

*

Front

Wildcard

Back

WHERE

Front

Constrains the result set Comes after the FROM clause Contains boolean expressions Only matching rows are in the result set ---------------------------------- where FirstName like '%'

Back