SQL Flashcards
1
Q
What is SQL
A
Standard Query language
2
Q
SQL Equivalent of “print”
A
SELECT
3
Q
How to ensure only one values is returned if it is repeated in many records
A
DISTINCT operator
4
Q
Vertical columns
A
Field
5
Q
Horizontal row
A
Record
6
Q
How to filter récords based on specific criteria
A
WHERE operator
7
Q
Not equal
A
<>
8
Q
‘In a certain range’
A
BETWEEN
9
Q
Structure a JOIN
A
SELECT ‘ ’
FROM «Table_1»
JOIN “Table_2” ON
Field.Table_1 = Field.Table_2
10
Q
Update clause
A
UPDATE “”
SET ‘field’ = ‘value’
WHERE ‘field’ = ___
11
Q
Delete clause
A
DELETE FROM “”
WHERE ‘field’ = ___
12
Q
Insert clause
A
INSERT INTO “”
VALUES (‘V1’, ‘V2’, …)
