还剩1页未读,继续阅读
文本内容:
【Java数据库】sql笔试题 create tabledeptdeptno var10primary key,dname var10;create tableempempno var10primary key,ename var10,job var10,mgr var10,sal var10,deptno var10references deptdeptno;dept;emp;into deptvalues\1\,\事业部\;into deptvalues\2\,\销售部\;into deptvalues\3\,\技术部\;into empvalues\01\,\jacky\,\clerk\,\tom\,\1000\,\1\;into empvalues\02\,\tom\,\clerk\,\\,\2000\,\1\;into empvalues\07\,\biddy\,\clerk\,\\,\2000\,\1\;into empvalues\03\,\jenny\,\sales\,\pretty\,\600\,\2\;into empvalues\04\,\pretty\,\sales\,\\,\800\,\2\;into empvalues\05\,\buddy\,\jishu\,\canndy\,\1000\,\3\;into empvalues\06\,\canndy\,\jishu\,\\,\1500\,\3\;select*from dept;select*from emp;--1列出emp表中各部门的部门号,最高工资,最低工资select deptno as部门号,maxsal as最高工资,minsal as最低工资from empgroup bydeptno;--2列出emp表中各部门job为\CLERK\的员工的最低工资,最高工资select maxsalas最高工资,minsal as最低工资,deptnoas部门号from empwhere job=\clerk\group bydeptno;--
3...。