--查询学过编号为"01"并且也学过编号为"02"的课程的同学的信息 select*fromstudentwheres_idin(selectt1.s_idfromscore t1, score t2wheret1.s_id=t2.s_idandt1.c_id='01'andt2.c_id='02'); selecta.*fromstudent a, score b, score cwherea.s_id=b.s_idanda.s_id=c.s_idandb.c_id...
五、设计题 1. USE Xk GO SELECT Teacher AS '教师名',CouNo AS '课程号',CouName AS '课程名' FROM Course ORDER BY Teacher DESC,CouNo GO 2. USE Xk GO Select CouName as ‘课程名称’ From Course Where CouNo='004' or CouNo='007' or CouNo='013' go 3. USE...
3、毕业证、学位证证书编号:往届生需要,找不到可以登陆学信档案查询,主要用到左下角的证书编号。 4、提前确认学信网账号信息:在报名前,提前确认自己的学信网账号状态,注册并记好密码(很多同学忘记了),同时登录学信档案核实学历(学籍)信息...
--查询学过编号为"01"并且也学过编号为"02"的课程的同学的信息 select*fromstudentwheres_idin(selectt1.s_idfromscore t1, score t2wheret1.s_id=t2.s_idandt1.c_id='01'andt2.c_id='02'); selecta.*fromstudent a, score b, score cwherea.s_id=b.s_idanda.s_id=c.s_idandb.c_id...