Lesson 3 Flashcards
(9 cards)
1
Q
Keywords
A
Considered a reserved SQL word.
2
Q
SELECT
A
Used in a query statement to retrieve data rows from database tables.
3
Q
FROM
A
Used in a query statement before the table name.
4
Q
WHERE Clause
A
Used to filter rows and only retrieve those that meet a specified condition.
5
Q
Column Names
A
Defined when the table was created.
6
Q
Filter Rows
A
Retrieve only the rows that meet a specified condition instead of all the data rows.
7
Q
Limit Columns
A
Retrieve only the columns in a table that are needed.
8
Q
Execute
A
Run a query statement to retrieve a result-set.
9
Q
SQL Syntax
A
Rules and guidelines that must be followed as SQL queries are written.
