文件名称:SQL答案.doc全部答案用文档写的
文件大小:292KB
文件格式:DOC
更新时间:2012-07-06 15:48:58
SQL答案.doc
2-01: 1.select * from city 2.select distinct OrderDate from orders 3.select * from suppliers where SuppCode='HHT' 4.select * from suppliers where SuppCode!='HHT' 5.select Descriptions,UnitPrice from products where UnitPrice between 0 and 20 6.select DistriNum,BossName,Company from distributors where DistriNum in (1006,1009,1013,1014,1017) 7.select substring(Phone,1,3) from distributors 8.select Company,Phone,Address from distributors where BossName like'王%' 2-02:。。。。。。。。。。