Fichas
SQL
Fichas del 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
Información
- Descripción
- A level (4.10) IT Fichas sobre SQL, creado por Ethan Fidzinski el 23/02/2026.
- Creado por
- Ethan Fidzinski
- Visitas
- 0
- Valoración