Untitled
unknown
sql
4 months ago
843 B
5
Indexable
Create TABLE Employees ( Department varchar(50), FirstName varchar(10), LastName varchar(10), ) Create TABLE Products ( ProductID varchar(20), ProductName varchar(20), Category varchar(20), Price varchar(20), ) Create TABLE Customers ( CustomerID varchar(20), CustomerName varchar(20), City varchar(20), Country varchar(20), ) SELECT DISTINCT Department FROM Employees; SELECT DISTINCT FirstName, LastName FROM Employees; SELECT ProductID, ProductName, Category, Price FROM Products ORDER BY Price ASC; SELECT ProductID, ProductName, Category, Price FROM Products ORDER BY Category ASC, Price DESC; SELECT CustomerID, CustomerName, City, Country FROM Customers WHERE CustomerName LIKE 'A%'; SELECT CustomerID, CustomerName, City, Country FROM Customers WHERE CustomerName LIKE '%son%'
Editor is loading...
Leave a Comment