Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

28 cards

()

Section 1

Preview this deck

LIMIT

Front

1 / 28

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 (28)

Section 1

(28 cards)

LIMIT

Front

Clause that lets you specify the maximum number of rows the result set will have.

Back

AND

Front

An operator that combines two conditions. Both conditions must be true for the row to be included in the result set.

Back

AS

Front

A keyword in SQL that allows you to rename a column or table using an alias.

Back

GROUP BY

Front

Clause used in SQL that is only used with aggregate functions. It is used in collaboration with SELECT statement to arrange identical data into groups.

Back

MAX ( )

Front

A function that takes the name of a column as an argument and returns the largest value in that column.

Back

MIN ( )

Front

A function that takes the name of a column as an argument and returns the smallest value in that column.

Back

OR

Front

An operator that filters the result set to only include rows where either condition is true.

Back

SELECT DISTINCT

Front

specifies that the statement is going to be a query that returns unique values in the specified column(s).

Back

BETWEEN

Front

This operator is used to filter the result set within a certain range. The values can be numbers, text or dates.

Back

HAVING

Front

Added to SQL because the WHERE keyword could not be used with aggregate functions.

Back

DELETE

Front

Statements that are used to remove rows from a table.

Back

Outer join

Front

Will combine rows from different tables even if the join condition is not met. Every row in the left table is returned in the result set, and if the join condition is not met, then NULL values are used to fill in the columns from the right table.

Back

SELECT

Front

Statements are used to fetch data from a database. Every query will begin with _____.

Back

IS NULL / IS NOT NULL

Front

Operators used with the WHERE clause to test for empty values.

Back

WITH

Front

this clause lets you store the result of a query in a temporary table using an alias. You can also define multiple temporary tables using a comma and with one instance of the ___ keyword. This clause is also known as common table expression (CTE) and subquery factoring.

Back

ORDER BY

Front

A clause that indicates you want to sort the result set by a particular column either alphabetically or numerically.

Back

UPDATE

Front

Statements that allow you to edit rows in a table.

Back

LIKE

Front

Special operator used with the WHERE clause to search for a specific pattern in a column.

Back

CREATE TABLE

Front

Creates a new table in the database. It allows you to specify the name of the table and the name of each column in the table.

Back

INSERT

Front

Statements are used to ad a new row to a table.

Back

ALTER TABLE

Front

Allows you to add columns to a table in a database

Back

SUM

Front

A function that takes the name of a column as an argument and returns the sum of all the values in that column.

Back

CASE

Front

These statements are used to create different outputs (usually in the SELECT statement). It is SQL's way of handling if-then logic.

Back

WHERE

Front

A clause that indicates you want to filter the result set to include only rows where the following condition is true.

Back

ROUND ( )

Front

A function that takes a column name and an integer as an argument. It rounds the values in the column to the number of decimal places specified by the integer.

Back

INNER JOIN

Front

Will combine rows from different tables if the join condition is true.

Back

AVG

Front

An aggregate function that returns the average avlue for a numeric column.

Back

COUNT

Front

Function that takes the name of a column as an argument and counts the number of rows where the column is not NULL.

Back