SQL笔试
2024-10-07 13:14:22
一、题目
二、练习数据
SELECT VERSION();
create table CDM_AGENT(ano VARCHAR(6),aname VARCHAR(8));
create table CDM_DEAL(sno VARCHAR(6),pno VARCHAR(6), volume VARCHAR(6));
create table CDM_PRODUCTION(pno VARCHAR(6),pname VARCHAR(6), pdate date);
create table CDM_SALAS(sno VARCHAR(6),sname VARCHAR(6), ano VARCHAR(6));
insert into CDM_AGENT (ano, aname)values ('1', 'AAA公司');
insert into CDM_AGENT (ano, aname)values ('2', 'BBB公司');
insert into CDM_AGENT (ano, aname)values ('3', 'CCC公司');
commit;
insert into CDM_DEAL (sno, pno, volume)values ('1', '1', '21');
insert into CDM_DEAL (sno, pno, volume)values ('1', '2', '56');
insert into CDM_DEAL (sno, pno, volume)values ('1', '3', '33');
insert into CDM_DEAL (sno, pno, volume)values ('2', '2', '120');
insert into CDM_DEAL (sno, pno, volume)values ('2', '1', '32');
insert into CDM_DEAL (sno, pno, volume)values ('2', '3', '26');
insert into CDM_DEAL (sno, pno, volume)values ('3', '1', '73');
insert into CDM_DEAL (sno, pno, volume)values ('3', '3', '45');
insert into CDM_DEAL (sno, pno, volume)values ('4', '2', '111');
insert into CDM_DEAL (sno, pno, volume)values ('4', '3', '84');
insert into CDM_DEAL (sno, pno, volume)values ('5', '3', '52');
insert into CDM_DEAL (sno, pno, volume)values ('5', '1', '38');
insert into CDM_DEAL (sno, pno, volume)values ('5', '2', '91');
insert into CDM_DEAL (sno, pno, volume)values ('6', '2', '36');
insert into CDM_DEAL (sno, pno, volume)values ('6', '3', '48');
insert into CDM_DEAL (sno, pno, volume)values ('6', '1', '15');
commit;
insert into CDM_PRODUCTION (pno, pname, pdate)values ('1', '产品A', str_to_date('2015/06/07', '%Y/%m/%d'));
insert into CDM_PRODUCTION (pno, pname, pdate)values ('2', '产品B', str_to_date('2016/06/07', '%Y/%m/%d'));
insert into CDM_PRODUCTION (pno, pname, pdate)values ('3', '产品C', str_to_date('2017/06/07', '%Y/%m/%d'));
commit;
insert into CDM_SALAS (sno, sname, ano)values ('1', '小赵', '2');
insert into CDM_SALAS (sno, sname, ano)values ('2', '小钱', '2');
insert into CDM_SALAS (sno, sname, ano)values ('3', '小孙', '3');
insert into CDM_SALAS (sno, sname, ano)values ('4', '小李', '1');
insert into CDM_SALAS (sno, sname, ano)values ('5', '小石', '3');
insert into CDM_SALAS (sno, sname, ano)values ('6', '小刘', '1');
commit;
答案：
1、
2、
3、
4、
5、
6、
7、
8、
9、
最新文章
- Node.js入门（一）
- JUnit4 中@AfterClass @BeforeClass @after @before的区别对比
- EF-CodeFirst-2玩的嗨
- 无线安全专题01--kali破解WPA
- OpenJudge 2756 二叉树
- 动态规划——C编辑最短距离
- iOS之Xcode 8.0真机调试运行：This ** is running iOS 10.1.1 (14B100), which may not be supported
- “&”详解
- Django REST framework使用ViewSets的自定义路由实现过程
- Storm实践
- mysql 合并left join 数据条目
- Mysql：查询每个月下的数据，根据状态或者年份的sql语句
- 7-25 :active :after :before :disabled
- C++模板、.vimrc和一些Linux配置
- Java和Php比较
- 一脸懵逼加从入门到绝望学习hadoop之 org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=Administrator, access=WRITE, inode="/":root:supergroup:drwxr-xr报错
- Hibernate的实体类中为什么要继承Serializable？
- 关于promise自己的理解
- iphone上点击div会出现半透明灰色背景以及margin失效
- HashMap源码学习