によって Bryan Camelo 3日前.
35
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) 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