Flashcards
SQL
Cards in this deck (8)
- 1SELECT QueryRetrieves data from a specified table
SELECT
FROM
[WHERE ]
[ORDER BY [ASC|DESC]] - 2DELETE QueryDeletion of
entire record/s
DELETE
FROM
[WHERE ] - 3UPDATE queryChanges existing fields of a record in a table
UPDATE
SET =[,=…]
WHERE - 4INSERT queryAdds a new record to a table
INSERT
INTO [(,…)]
VALUES ([,,…]) - 5CREATE TABLE queryCREATE TABLE [],
[], - 6Operators (7 of them)Equal to -- =
Not Equal to -- <>
Greater than -- >
Greater than/equal to -- >=
Lesser than -- <
Lesser than/equal to -- <=
Is -- IS - 7Inner Join (select)Used to define what you want in the table apart from the link.
- 8Differences between inner join and filtered cross joinInner join uses ON Syntax to define the fields that link
Information
- Description
- A level IT (4.10) Flashcards on SQL, created by Ethan Fidzinski on 23/02/2026.
- Created by
- Ethan Fidzinski
- Views
- 0
- Rating