SQL Flashcards
(31 cards)
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
ALTER TABLE syntax
26
Autoincrementing a field in a table
27
CREATE VIEW syntax
28
GROUP BY syntax
29
SQL aggregate functions
30
SQL scalar functions
31
