1. SELECT ContactName,City
FROM customers;
FROM customers;
2. SELECT DISTINCT City
FROM customers;
3. SELECT * FROM customers
WHERE country='Mexico';
4. SELECT * FROM `customers`
WHERE country<>'Canada'
5. SELECT `ID`, `ContactName`, `Address`, `City`, `PostalCode`, `Country` FROM `customers` WHERE ID<=10
6.
7. SELECT * FROM customers
ORDER BY city;
8.
9.
10.
7. SELECT * FROM customers
ORDER BY city;
8.
9.
10.
Комментариев нет:
Отправить комментарий