Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
SQL

SQL

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
27 cards
()
Section 1

Preview this deck

<

Front

1 / 27

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (27)

Section 1

(27 cards)

<

Front

Less than

Back

LIKE '%Tofu'

Front

would match any character field or expression where Tofu was at the end

Back

Aggregate Function

Front

Performs a calculation on a set of values and then returns a single value

Back

JOIN

Front

Joins an additional table

Back

AND

Front

All of the conditions must be true

Back

AVG()

Front

Used to calculate the average of numeric fields

Back

Null value

Front

the field is empty

Back

SELECT

Front

Used to retrieve data from a database

Back

>

Front

Greater than

Back

HAVING

Front

Used to filter based on aggregated results

Back

DISTINCT

Front

Used to display something that is only listed once

Back

<> or !=

Front

Not equal to

Back

SUM()

Front

Adds up the non-null values of the function argument

Back

Rows

Front

Records

Back

>=

Front

Greater than or equal to

Back

COUNT()

Front

Counts the number of non-null values of the field in the parentheses

Back

IN

Front

Useful when one wants to know if a field falls within a known set of values

Back

GROUP BY

Front

Indicate that we want our aggregate value to be calculated for each unique value of the group by field

Back

Columns

Front

Fields

Back

LIKE '%Tofu%'

Front

would match any field or expression where Tofu was anywhere in the field or expression

Back

<=

Front

Less than or equal to

Back

LIKE 'Tofu%'

Front

would match any character field or expression where Tofu was at the beginning

Back

=

Front

equal to

Back

OR

Front

One of several conditions needs to be true

Back

FROM

Front

Indicates the table that the fields come from

Back

WHERE

Front

Used to limit the records returned to just data that matches our needs

Back

ORDER BY

Front

Used to sort the results of a query

Back