Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

43 cards

()

Section 1

Preview this deck

>= (Greater or equal to)

Front

1 / 43

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (43)

Section 1

(43 cards)

>= (Greater or equal to)

Front

A combined comparison

Back

> (Greater than)

Front

The compared value must be larger than the requested value

Back

FROM

Front

table name

Back

Left Join

Front

the query will show ALL records from the LEFT table in the final output

Back

DESC

Front

descending order

Back

Optional Clauses

Front

WHERE, ORDER by, LIMIT

Back

SELECT

Front

list of fields name

Back

COUNT(DISTINCT)

Front

_______________ is an aggregate expression to count the number of unique values in the VendorID column:

Back

Inner Join

Front

This type of join will compare both tables and only retrieve records in which there are matching values in both tables

Back

WHERE

Front

conditional checks and filters

Back

Right Join

Front

the query will show ALL records from the RIGHT table in the final output

Back

COUNT

Front

counts the number of records

Back

SELECT clause

Front

defines that data needs to be retrieved from a database

Back

Display Currency

Front

Use a combination of CONCAT and FORMAT

Back

AVG

Front

Average within a data set.

Back

BETWEEN

Front

an be used to check for ranges

Back

FORMAT()

Front

Similar to round except that it can pad numbers with zeros to meet the specified number of decimal digits

Back

<= (Less or equal to)

Front

A combined comparison

Back

Required Clauses

Front

SELECT and FROM

Back

!=

Front

compared value must not be equal to the requested value

Back

ORDER by clause

Front

handles any sorting of the final results

Back

LIKE

Front

% sign is a wild card, so it means there can be any number of characters before the 'th' and/or any number of characters after the 'th'. If the first %

Back

WHERE clause

Front

primary job of defining which records are of interest and should be included in the results, allows us to specify conditional checks to filter results to only what we are interested in

Back

FROM clause

Front

defines the tables in which information should be retrieved from

Back

ASC

Front

ascending order

Back

INSERT

Front

input new data

Back

GROUP by

Front

is consolidate based on some type of condition

Back

LIMIT

Front

amount of records

Back

DELETE

Front

Used to remove a record of data from a table

Back

USING clause

Front

Performs an equijoin based on the same specified column name.

Back

= (Equals)

Front

The compared value must be the same as the requested value

Back

Boolean Field

Front

In databases, a field that sores only two values True or false

Back

Alias

Front

overwriting the name displayed in the output results, it's not actually changing the name of the field

Back

AND

Front

means that both conditions must be true

Back

LIMIT clause

Front

defines a cap on the number of records returned in the results

Back

OR

Front

means at least one conditional check must be True for the record to be retrieved

Back

CONCAT

Front

function can have multiple parameters, a comma separates each one

Back

< (Less than)

Front

The compared value must be smaller than the requested value

Back

IN

Front

can be used to simplify the WHERE clause

Back

UPDATE

Front

Used to modify or adjust data within the tables of a database, such as changing someone's name

Back

ORDER BY

Front

list of fields

Back

ROUND

Front

Round a number to a specified number of decimals

Back

Fall Outer Join

Front

combines the records of the Left Join and Right Join

Back