Sql

Front 1

Select

Back 1

Select data from a database

SELECT column_name, column_name FROM table_name;

Front 2

Distinct

Back 2

Shows distinct values in the table given parameters

SELECT DISTINCT...

Front 3

Where

Back 3

Determines specific criteria of data

SELECT column_name, column_name FROM table_name

WHERE column_name operator value;

Front 4

Order By

Back 4

Organizes the data

SELECT column_name, column_name FROM table_name

WHERE column_name operator value ORDER BY column_name ASC/DESC, column_name ASC/DESC;

Front 5

Insert Into

Back 5

Adds values into a preexisting table

INSERT INTO table_name column 1, column 2, column 3 VALUES value 1, value 2, value 3;

Front 6

Update

Back 6

Changes the values in a preexisting table

UPDATE table_name

SET column 1 = value 1, column 2 = value 2,... WHERE some_column = some_value;

Front 7

Delete

Back 7

Deletes records in a preexisting table

DELETE FROM table_name

WHERE some_column = some_value

Front 8

Select Top/ Limit

Back 8

Limits the output based on the criteria

SELECT TOP number/percent column_name

FROM table_name;

SELECT column_name FROM table_name LIMIT 20 PERCENT;

Front 9

Like

Back 9

Uses a pattern in order to determine a criteria. Usually used with wildcards

SELECT column_name FROM table_name

WHERE column_name LIKE '?a';