Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
What does SELECT do?
|
SELECT Extracts data from a database.
|
|
What does < >mean?
|
< > means not equal.
|
|
What does ORDER BY do?
|
ORDER BY is when you want to sort your SQL result sets by some column(s).
|
|
What does WHERE do?
|
WHERE is used to select data conditionally, by adding it to already existing SQL SELECT query.
|
|
What does >= mean?
|
>= mean greater than equal to.
|
|
What does LIKE mean?
|
LIKE is when you want to specify a search condition within your SQL WHERE, based on a part of a column contents.
|
|
What does GROUP BY mean?
|
GROUP BY is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certain database table column.
|
|
What does OR & AND mean?
|
AND is used when you want to specify more than one condition in your WHERE, and at the same time you want all conditions to be true.
|
|
What does <= mean?
|
<= mean less than or equal to.
|
|
What does UPDATE mean?
|
UPDATE changes the data in already existing database row(s) and usually we need to add a conditional SQL WHERE clause to our SQL UPDATE statement in order to specify which row(s) we intend to update.
|