TERCER CORTE SCRIP

04.06.2011 22:27


SELECT "nombre_columna" FROM "nombre_tabla"

 SELECT DISTINCT store_name FROM Store_Information

SELECT store_name

FROM Store_Information
WHERE Sales > 1000
OR (Sales < 500 AND Sales > 275)

 SELECT *

FROM Store_Information
WHERE store_name IN ('Los Angeles', 'San Diego')

 SELECT "nombre_columna"
FROM "nombre_tabla"
[WHERE "condición"]
ORDER BY "nombre_columna" [ASC, DESC]
 

SELECT COUNT(store_name)

FROM Store_Information
SELECT COUNT(DISTINCT store_name)
FROM Store_Information
 
 
 
 
 
 
 
 
 
SELECT "nombre1_columna", SUM("nombre2_columna")
FROM "nombre_tabla"
GROUP BY "nombre1-columna"
SELECT store_name, SUM(Sales)
FROM Store_Information
GROUP BY store_name
SELECT "nombre1_columna", SUM("nombre2_columna")
FROM "nombre_tabla"
GROUP BY "nombre1_columna"
HAVING (condición de función aritmética
 
SELECT store_name, SUM(sales)
FROM Store_Information
GROUP BY store_name
HAVING SUM(sales) > 1500
SELECT A1.region_name REGION, SUM(A2.Sales) SALES
FROM Geography A1, Store_Information A2
WHERE A1.store_name = A2.store_name
GROUP BY A1.region_name
SELECT Geography.region_name REGION, SUM(Store_Information.Sales) SALES

 

 

Volver