SQL Command Options (BASIC) Flashcards Preview

SQL > SQL Command Options (BASIC) > Flashcards

Flashcards in SQL Command Options (BASIC) Deck (24)
Loading flashcards...
1

Describes the structure of a table

DESCRIBE

2

Inserts row(s) into a table

INSERT

3

Selects attributes from rows in one or more tables or views

SELECT

4

Restricts the selection of rows based on a conditional expression

WHERE

5

Groups the selected rows based on one or more attributes

GROUP BY

6

Restricts the selection of grouped rows based on a condition

HAVING

7

Orders the selected rows based on one or more attributes

ORDER BY

8

Modifies an attribute's values in one or more table's rows

UPDATE

9

Deletes one or more rows from a table

DELETE

10

Permanently saves data changes

COMMIT

11

Restores data to its original values

ROLLBACK

12

Comparison operators

=, , <=, >=, <>, !=

13

Logical operators

AND/OR/NOT

14

Checks whether an attribute value is within a range

BETWEEN

15

Checks whether an attribute value is null

IS NULL

16

Checks whether an attribute value matches a given string pattern

LIKE

17

Checks whether an attribute value matches any value within a value list

IN

18

Checks whether a subquery returns any rows

EXISTS

19

Limits values to unique values

DISTINCT

20

Returns the number of rows with non-null values for a given column

COUNT

21

Returns the minimum attribute value found in a given column

MIN

22

Returns the maximum attribute value found in a given column

MAX

23

Returns the sum of all values for a given column

SUM

24

Returns the average of all values for a given column

AVG