Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

DBI DDS15 Anatomy of a SQL Statement

memorize.ai (lvl 286)

(0)

14 cards

()

Section 1

Preview this deck

Arithmetic expression

Front

1 / 14

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 (14)

Section 1

(14 cards)

Arithmetic expression

Front

A mathematical equation.

Back

Select clause

Front

Specifies the columns to be displayed

Back

Selection

Front

The capability in SQL to choose the rows in a table returned from a query.

Back

Projection

Front

The capability in SQL to choose the columns in a table that you want returned from a query.

Back

Arithmetic operator

Front

A symbol used to perform an operation on some values.

Back

Select statement

Front

Retrieves information from the database

Back

Column

Front

An implementation of an attribute or relationship in a table.

Back

Column alias

Front

Renames a column heading.

Back

NULL

Front

A value that is unavailable, unassigned, unknown, or inapplicable.

Back

Keyword

Front

An individual SQL statement

Back

From clause

Front

Specifies the table containing the column listed in the select clause

Back

Statement

Front

A combination of the two clauses

Back

Clause

Front

Part of a SQL statement

Back

Join

Front

Display data from two or more related tables.

Back