Kategorier: Alla - union - sql

av Bryan Camelo för 1 dag sedan

27

SQL (Lenguaje Estructurado de Consulta)

Structured Query Language (SQL) is a powerful tool for managing and manipulating databases. It includes various operations such as UNION, UNION ALL, INTERSECT, and EXCEPT which allow for combining and filtering data sets.

SQL (Lenguaje Estructurado de Consulta)

SQL (Lenguaje Estructurado de Consulta)

Consultas a Múltiples Tablas

FULL JOIN
RIGHT JOIN
LEFT JOIN
INNER JOIN

Subconsultas

Correlacionadas
Anidadas
WHERE, HAVING, FROM

Operaciones sobre Conjuntos

EXCEPT
INTERSECT
UNION vs. UNION ALL

Funciones y Operadores

Operadores
Comparación

=, !=, <, >, <=, >=

Lógicos

AND, OR, NOT

Aritméticos

+, -, * , /, %

Funciones de fecha
DATE_FORMAT()
DATE_ADD()
NOW()
Funciones de cadena
SUBSTRING()
LENGTH()
CONCAT()
Funciones de agregación
MAX()
MIN()
COUNT()
AVG()
SUM()

Sentencias SQL

TCL (Transaction Control Language)
SAVEPOINT
ROLLBACK
COMMIT
DCL (Data Control Language)
REVOKE
GRANT
DDL (Data Definition Language)
CREATE INDEX
DROP TABLE
ALTER TABLE
CREATE TABLE
DML (Data Manipulation Language)
DELETE
UPDATE
INSERT
SELECT