Session 13

SQL Statements

SELECT * FROM CUSTOMERS

SELECT CustomerID, CustomerName FROM CUSTOMERS
SELECT ContactName, CustomerName FROM CUSTOMERS
CustomerName, Address, City, PostalCode FROM Customers WHERE Country = 'UK';
SELECT ContactName, CustomerName FROM Customers ORDER BY ContactName;

SELECT Country, COUNT() FROM Customers GROUP BY Country;

SELECT Country, COUNT() FROM Customers GROUP BY Country ORDER BY COUNT() DESC, Country ASC;
SELECT Country, COUNT() FROM Customers GROUP BY Country
HAVING Count() > 10 ORDER BY COUNT(*) DESC, Country ASC;
INSERT INTO Shippers VALUES ('4', 'On Time Delivery', '(503) 555 0123)';

UPDATE Products

UPDATE Products SET Price = Price + 1;
UPDATE Products SET Price = Price - 1;
UPDATE Shippers SET ShipperName = 'On-Time Delivery' WHERE ShipperID = 4;
DELETE FROM Shippers WHERE ShipperID = 4;
CONTENT :