创建表和输入数据 CREATE TABLE STUDENT (SNO VARCHAR(3) NOT NULL, SNAME VARCHAR(4) NOT NULL, SSEX VARCHAR(2) NOT NULL, SBIRTHDAY DATETIME, CLASS VARCHAR(5)) go CREATE TABLE COURSE (CNO VARCHAR(5) NOT NULL, CNAME VARCHAR(10) NOT NULL, TNO VA
Python/ MySQL练习题(一) 查询“生物”课程比“物理”课程成绩高的所有学生的学号 SELECT * FROM ( SELECT * FROM course LEFT JOIN score ON score.course_id = course.cid WHERE course.cname = '生物' ) AS A INNER JOIN ( SELECT * FROM course LEFT JOIN score ON score.course_id = course.cid WHE
python/MySQL练习题(二) 查询各科成绩前三名的记录:(不考虑成绩并列情况) select score.sid,score.course_id,score.num,T.first_num,T.second_num from score left join ( select sid, (select num from score as s2 where s2.course_id = s1.course_id order by num desc limit 0,1) as first_nu
SQL与HQL练习题 中的所有员工. select * from emp where deptno = 30 from Emp e where e.deptno = 30 2. 列出所有办事员(CLERK)的姓名.编号和部门编号. select t.ename,t.empno,t.deptno from emp t where t.job = 'CLERK' select t.ename,t.empno,t.deptno from Emp t where t.job = 'CLERK' 3