2.select * from 表名;
3.select * from HumanResources.Department where name like"Pro%";
4.select name from HumanResources.Department where name like"Sale%" and len(name)=5;
5.select EmployeeID,VacationHours from HumanResources.Employee where 休假時間<=50 and 休假時間>=40;
6.select * from SalesOrderHeader where date="2004-6-6";
7.select EmployeeID,Rate,rate*8 as 每天的工資 from HumanResources.EmployeePayHistory;[已知不夠詳細]
8.select top 10 * from Employee;
9. select EmployeeID,Title,LoginID from HumanResources.Employee where Title=Recruiter or Title=Stocker or Title=Buyer ;
10.select 客戶ID,編號 from 表 where TerritoryID=4;
11. select * from HumanResources.Employee;
12.select EmployeeID,NationalIDNumber,ContactID,HireDate from HumanResources.Employee where row()>15;
13.select top 10 EmployeeID,NationalIDNumber,ContactID,HireDate from HumanResources.Employee where row()>15;
14.select * from SalesOrderHeader where 成本>2000;
15.select * from Department where GroupName='Research' or GroupName='Development';
16.select DepartmentID as Department Number,Name as Department Name from HumanResources.Department;
17.select Title from Employee where Title like"PR%";
18.select SalesPersonID,isnull(SalesQuota,0) from Sales.SalesPerson;
19.select Name+GroupName as Department from Department where Name' department comes under ' and GroupName=' group';
20.select * from SalesOrderHeader where 名稱='Cable Lock'and ProductID=843;