BASICS

Question 1

Used to retrieve data from a database

Answer 1

SELECT

Question 2

Specifies the table(s) to retrive data from

Answer 2

FROM

Question 3

Filters the results based on a specified condition

Answer 3

WHERE

Question 4

Adds new data into a table

Answer 4

INSERT INTO

Question 5

Modifies existing data in a table

Answer 5

UPDATE

Question 6

Removes data from a table

Answer 6

DELETE FROM

Question 7

=

Answer 7

Equal to

Question 7

<

Answer 7

Less than

Question 7

<>

Answer 7

Noyt equal to

Question 7

>

Answer 7

Greater than

Question 8

<=

Answer 8

Less than or equal to

Question 9

> =

Answer 9

Greater than or equal to

Question 10

AND

Answer 10

Logical AND

Question 11

OR

Answer 11

Logical OR

Question 12

NOT

Answer 12

Logical NOT

Question 13

Returns the number of rows that match a specified criteria

Answer 13

COUNT

Question 14

Returns the total sum of a numeric column

Answer 14

SUM

Question 15

Returns the average value of a numeric column

Answer 15

AVG

Question 16

Returns the smallest value of the selected column

Answer 16

MIN

Question 17

Returns the largest value of the selected column

Answer 17

MAX

Question 18

Sorts the result set in ascending or descending order

Answer 18

ORDER BY

Question 19

Group rows that have the same values into summary rows

Answer 19

GROUP BY

Question 20

Filters the results of a GROUP BY clause

Answer 20

HAVING

Question 21

Returns only unique values

Answer 21

DISTINCT

Question 22

Searches for a pattern

Answer 22

LIKE

Question 22

Selects values within a given range

Answer 22

BETWEEN