SQL Tutorial Indice del sito

Tutorial de SQL

Comandi SQL

• SQL SELECT
  
• SQL DISTINCT
  
• SQL WHERE
  
• SQL AND OR
  
• SQL IN
  
• SQL BETWEEN
  
• SQL LIKE
  
• SQL ORDER BY
  
• SQL Funzioni
  
• SQL COUNT
  
• SQL GROUP BY
  
• SQL HAVING
  
• SQL ALIAS
  
• SQL Join
  
• SQL Outer Join
  
• SQL CONCATENATE
  
• SQL SUBSTRING
  
• SQL TRIM
  
• SQL LENGTH
  
• SQL REPLACE
  
• SQL DATEADD
  
• SQL DATEDIFF
  
• SQL DATEPART
  
• SQL GETDATE
  
• SQL SYSDATE
  

Modifica delle Tabelle

• SQL CREATE TABLE
  
• SQL CONSTRAINT
  
• SQL NOT NULL
  
• SQL DEFAULT
  
• SQL UNIQUE
  
• SQL CHECK
  
• SQL Chiave Primaria
  
• SQL Chiave Esterna
  
• SQL CREATE VIEW
  
• SQL CREATE INDEX
  
• SQL ALTER TABLE
  
• SQL DROP TABLE
  
• SQL TRUNCATE TABLE
  
• SQL USE
  
• SQL INSERT INTO
  
• SQL UPDATE
  
• SQL DELETE FROM
  
  

SQL Avanzato

• SQL UNION
  
• SQL UNION ALL
  
• SQL Vista in Linea
  
• SQL INTERSECT
  
• SQL MINUS
  
• SQL Sottoquery
  
• SQL WITH
  
• SQL EXISTS
  
• SQL CASE
  
• SQL SEQUENCE e NEXTVAL
  
• SQL NULL
  
• SQL ISNULL
  
• SQL IFNULL
  
• SQL NVL
  
• SQL COALESCE
  
• SQL NULLIF
  

Sintassi SQL

Indice del sito