Single-Table SELECT Statements
Below is a list of single-table SELECT statements used to query data from a database:
- SELECT * FROM Customers;
- SELECT CustomerID, CustomerName FROM Customers;
- SELECT CustomerName, Address, City, PostalCode FROM Customers WHERE Country = 'UK';
- SELECT ContactName, CustomerName FROM Customers ORDER BY ContactName ASC;
- SELECT count(*) FROM Customers;
- SELECT Country, count(*) FROM Customers GROUP BY Country;
- SELECT Country, count(*) AS CustomerCount FROM Customers GROUP BY Country ORDER BY CustomerCount DESC, Country ASC;
- SELECT Country, COUNT(*) AS CustomerCount FROM CUSTOMERS GROUP BY Country HAVING count(*) > 10 ORDER BY CustomerCount DESC, Country ASC;
INSERT, UPDATE, and DELETE Statements
Below is a list of INSERT, UPDATE, and DELETE statements used to modify data in a database:
- INSERT INTO SHIPPERS (ShipperID, ShipperName, Phone) VALUES (4, 'On Time Delivery', '(503) 555 0123');
- 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;