BD Aplicada

BD Aplicada

1. Operaciones básicas

   • SELECT
     • SELECT campos FROM tabla
   • INSERT
     • INSERT INTO tabla VALUE valor
   • UPDATE
     • UPDATE tabla SET valor=valor
   • DELETE
     • DELETE FROM tabla

2. Operadores Avanzados

   • TOP
     • SELECT TOP
   • BETWEEN
     • WHERE campo BETWEEN num AND num
   • LIKE
     • WHERE campo LIKE '%cadena'
   • IN
     • WHERE campo IN ('cadena','cadena')
   • INNER JOIN
     • FROM tabla INNER JOIN tabla ON campo = campo
     • LEFT JOIN
     • RIGHT JOIN
     • FULL JOIN
   • UNION

3. Funciones de Agregado

   • AVG, SUM, MAX, MIN, COUNT
     • SELECT AVG(campo)
   • DISTINCT
     • SELECT COUNT(DISTINCT cliente)
   • GROUP BY

4. Funciones Escalares

   • UPPER LOWER
     • SELECT UPPER(campo) AS Nombre_campo
   • SUBSTRING
     • SELECT SUBSTRING(campo,1,3)
   • LEN
     • SELECT LEN(campo) AS caracteres