Flashcards
SQL
Flashcards do conjunto (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
Informações
- Descrição
- A level IT (4.10) FlashCards sobre SQL, criado por Ethan Fidzinski em 23-02-2026.
- Criado por
- Ethan Fidzinski
- Visualizações
- 0
- Avaliação