Karteikarten
SQL
Karten in diesem Stapel (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
Informationen
- Beschreibung
- A level IT (4.10) Karteikarten am SQL, erstellt von Ethan Fidzinski am 23/02/2026.
- Erstellt von
- Ethan Fidzinski
- Aufrufe
- 0
- Bewertung