SQL Flashcards
1
Q
ORDER BY syntax
A
2
Q
INSERT syntax
A
3
Q
UPDATE syntax
A
4
Q
DELETE syntax
A
5
Q
TOP syntax
A
6
Q
LIKE syntax
A
7
Q
SQL wildcards
A
8
Q
IN operator syntax
A
9
Q
BETWEEN operator syntax
A
10
Q
AS syntax on tables
A
11
Q
AS syntax on columns
A
12
Q
JOIN types
A
13
Q
[INNER] JOIN syntax
A
14
Q
LEFT JOIN syntax
A
15
Q
RIGHT JOIN syntax
A
16
Q
FULL JOIN syntax
A
17
Q
UNION syntax
A
18
Q
SELECT INTO syntax
A
19
Q
CREATE DATABASE syntax
A
20
Q
CREATE TABLE syntax
A
21
Q
CONSTRAINT types
A
22
Q
CREATE INDEX syntax
A
23
Q
DROP syntax
A
24
Q
TRUNCATE syntax
A
25
Q
ALTER TABLE syntax
A
26
Q
Autoincrementing a field in a table
A
27
Q
CREATE VIEW syntax
A
28
Q
GROUP BY syntax
A
29
Q
SQL aggregate functions
A
30
Q
SQL scalar functions
A
31
Q
A
