BASICS Flashcards
1
Q
Used to retrieve data from a database
A
SELECT
2
Q
Specifies the table(s) to retrive data from
A
FROM
3
Q
Filters the results based on a specified condition
A
WHERE
4
Q
Adds new data into a table
A
INSERT INTO
5
Q
Modifies existing data in a table
A
UPDATE
6
Q
Removes data from a table
A
DELETE FROM
7
Q
=
A
Equal to
7
Q
<
A
Less than
7
Q
<>
A
Noyt equal to
7
Q
>
A
Greater than
8
Q
<=
A
Less than or equal to
9
Q
> =
A
Greater than or equal to
10
Q
AND
A
Logical AND
11
Q
OR
A
Logical OR
12
Q
NOT
A
Logical NOT