7.7 Introduction to SQL Flashcards
1
Q
SQL stands for
A
Structured Query Language
2
Q
What is SQL used for?
A
A language which can be used to create, query and add data to databases
3
Q
SQL syntax for querying a database
A
SELECT … FROM … WHERE …
4
Q
What does the wild card “*” do?
A
Selects all columns
5
Q
BETWEEN
A
Includes a range for the query
6
Q
LIKE
A
Searches for a pattern in the table
7
Q
ORDER BY
A
Allows a query to sort data by ascending or descending order