电商网站开发需求,开发网站能赚多少钱,微商货源类网站源码,做动漫网站最近有蛮多小伙伴在跳槽找工作#xff0c;但对于年限稍短的软件测试工程师#xff0c;难免会需要进行笔试#xff0c;而在笔试中#xff0c;基本都会碰到一道关于数据库的大题#xff0c;今天这篇文章呢#xff0c;就收录了下最近学员反馈上来的一些数据库笔试题#xf…最近有蛮多小伙伴在跳槽找工作但对于年限稍短的软件测试工程师难免会需要进行笔试而在笔试中基本都会碰到一道关于数据库的大题今天这篇文章呢就收录了下最近学员反馈上来的一些数据库笔试题包含答案
1、依据以下学生表、班级表按要求写 SQL 答案
1、 select * from student a left join class b on a.c_id b.id where score ( select max(score) from student)
2、 select b.name,count(*),avg(score) as avgScore from student a,class b where a.c_id b.id group by b.name order by avgScore;
2、Table A 保存客户的基本信息Table B 保存客户的资产负债信息。按要求写 SQL
答案
1select ID from A where name 李四; 2select NO,NAMEID from A,B where A.NO B.NO AND DEPOSIT 1000; 3select COUNTRY,count(*) FROM A GROUP BY COUNTRY;
4SELECT 80 后 as 年龄段sum(CREDIT) AS 信用卡余额 FROM A,B WHERE A.NO B.NO AND BIRTH 19800101 AND BIRTH 19900101 UNION SELECT 90 后 as 年龄段sum(CREDIT) AS 信用卡余额 FROM A,B WHERE A.NO B.NO AND BIRTH 19900101 AND BIRTH 20000101;
3、数据库(编写示例 sql) 答案
select orderNo, if(status1,新建,处理中) from OrderTrans; select DATE_FORMAT(a.crttime,%m-%d-%Y) ,username,count(*) from testCase a,User b where a.crtUser b.UserId group by DATE_FORMAT(a.crttime,%m-%d-%Y),b.username, having status 成功; select count(*),sum(amount),DATE_FORMAT(crttime,%m-%d-%Y) from OrderInfo group by DATE_FORMAT(crttime,%m-%d-%Y) 4、现有三张数据表如下学生资料表记录学生基本信息课程表记录课程基本信息成绩表记录每人各门课程成绩的信息1 个学生对应多个成绩1 个成绩只属于一个学生一个课程 答案
Select * from students where jg ‘湖北’ and birthday ‘1992-6-1’ order by no asc; Select avg(so.cj),min(so.cj),max(so.cj),sum(so.cj) from student st,course c,source so where st.no so.no and c.kebhso.kebh and st.name ‘王华’ group by st.no; Select st.no,st.name,st.bj,c.kebh,c.kcmc,so.cj from student st,course c,source so where st.no so.no and c.kebhso.kebh and st.name ‘张三’ order by so.cj desc; 5、有三张表 Contacts 库 Consultant 表、Basket 库 BaseOrder 表、Basket 库 OrderDetails 表按要求写 SQL 答案
Select Consultant.SubsidiaryID, BaseOrder.* from Consultant, BaseOrder where Consultant.ConsultantID BaseOrder.ConsultantID and Consultant.SubsidiaryID 29 order by Orderid desc; Select BaseOrder.ConsultantID,sum(OrderDetails.TotalPrice) from BaseOrder,OrderDetails where BaseOrder.OrderidOrderDetails.Orderid and month(OrderDate) 5 group by BaseOrder.ConsultantID; Insert into Consultant (ConsultantID,ConstultantStatusID,SubsidiaryID,Name) values (200000,10,29,’Gary’); Delete from Consultant where Name like ‘%Gary%’; Update BaseOrder set OrderDate sysdate() where ConsultantID in (select ConsultantID from BaseOrder where ConsultantID100003 order by OrderDate desc limit 0,1); ps小编个人收集啦许多软测资料希望能够帮到学软件测试的朋友们软件资料分享包括但不限于Java自动化测试、Python自动化测试、性能测试、web测试、APP测试
测试开发工具包appuim安装包、fiddler安装包也有配套视频教程、eclipse、git、jmeter、loadrunner、monkey、postman、soapul、Xmind等等
最后感谢每一个认真阅读我文章的人礼尚往来总是要有的虽然不是什么很值钱的东西如果你用得到的话可以直接拿走
这些资料对于【软件测试】的朋友来说应该是最全面最完整的备战仓库这个仓库也陪伴上万个测试工程师们走过最艰难的路程希望也能帮助到你
