nsjd.net
当前位置:首页 >> SQL这些题怎么做?? >>

SQL这些题怎么做??

select a.* from score a,score b where a.sno='3-105' and b.sno='3-245' and a.cno=b.cno and a.degree>b.degree ;

1 √ 2 × 3 √ 4 × 5 × 6 × 7 √ 8 × 9 × 10 ×

D,D,A,C,B ,B,C,D,C,D

备份 触发器 3. 关系 4. @@ 5. 记录 6. 数据 7. 实体 8. Windows 9. oder by 薪水 desc 10. 数据 11. max() 12. 修改 13. avg() 14. delete 15. 主键和外键 16. char(20) not null

2 alter table reader_info alter column rdr_type varchar(10); 4 ALTER TABLE reader_info ADD CONSTRAINT c_rdr_mail CHECK (rdr_mail like %@%); 6 插入语句是insert 修改语句是update 删除语句是delete

select 学生信息from table_namewhere avg(分数) between 75 and 80group by 学生信息having count(*)>=4

USE NorthwindGO--1SELECT ContactName 客户名称,CompanyName 公司名称,Address 地址,Phone 联系电话 FROM CustomersWHERE CompanyName LIKE 'Ri%'--2SELECT ProductID,ProductName,UnitPrice,CategoryName FROM Products JOIN Categories ON Pr...

SELECT PLAN_LIST,RENT,CORPUS,INTEREST,FACTRENT,CASEWHEN RENT=FACTRENT then '已回笼'WHEN RENTFACTRENT and 0

有问题联系我2511837361 --1 select couno,couname from course where course not in('004','007','013') --2 select student.stuno,student.stuname from student inner join stucou on student.stuno=stucou.stuno inner join course on couse...

select tname,prof from teacher where tdepart not in('计算机系','电子工程系') 这问题表述不明确,是指不是计算机系与电子工程系吗

网站首页 | 网站地图
All rights reserved Powered by www.nsjd.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com