SQL Server 2000 2007-3-10练习

2007-3-10
练习一 查找Categories(分类)表中名字中不包含"Con"的种类信息。

SELECT *
FROM Categories
WHERE (CategoryName NOT LIKE '%Con%')

练习二 查找Employees(雇员)表中City(城市)为Seattle(西雅图)或Tacoma或Redmond的员工编号，姓，名，入职日期，按年龄排序。

SELECT EmployeeID, LastName, FirstName, HireDate, BirthDate
FROM Employees
WHERE (City IN ('Seattle', 'Tacoma', 'Redmond'))
ORDER BY BirthDate