컴공지식/데이터베이스

SQL 형태들

개강한 공대생 2024. 11. 5. 13:56

SELECT * FROM Customers;

 

SELECT CustomerName, City FROM Customers;

 

SELECT Country FROM Customers;

 

SELECT DISTINCT Country FROM Customers;

 

SELECT COUNT(DISTINCT Country) FROM Customers;

 

SELECT * FROM Customers WHERE Country='Mexico';

 

SELECT *FROM Customers WHERE Country='Germany' AND City='Berlin';

 

SELECT * FROM Cusomers WHERE Country='Germany' AND (City='Berlin' OR City='Munchen');

 

SELECT * FROM Cusomers WHERE Country='Germany' AND NOT Country='USA';

 

SELECT * FROM Cusomers ORDER BY Country DESC;

 

SELECT * FROM Cusomers ORDER BY Country, CustomerName;

 

SELECT * FROM Cusomers ORDER BY Country ASC, CustomerName DESC;

 

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

 

SELECT CustomerName, ContactName, Address FROM Customers WHERE Address IS NULL;

 

SELECT CustomerName, ContactName, Address FROM Customers WHERE Address IS NOT NULL;

 

UPDATE Customers SET ContactName = 'Alfred Schmidt', City= 'Frankfurt' WHERE CustomerID = 1;

 

UPDATE Customers SET ContactName='Juan' WHERE Country='Mexico';

 

DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';