SQL Flashcards
1
Q
What does ORDER BY do?
A
Sorts the result-set in ascending or descending order.
Ascending by default, descending by use of DESC
2
Q
What does SELECT do?
A
Selects data from a database, storing it in a table called the ‘result-set’
3
Q
What does SELECT DISTINCT do?
A
Selects and returns only different values
4
Q
What does WHERE do?
A
Extracts data that meets a given condition
5
Q
What does AND do?
A
Displays a record if all conditions are met
6
Q
What does OR do?
A
Displays a record if one of the conditions is met
7
Q
What does NOT do?
A
Displays a record if the conditions are not true
8
Q
What does INSERT INTO do?
A
Inserts new records into a table
INSERT INTO table_name VALUES (value1, value2,…
9
Q
What is a NULL value?
A
A field with no value
