随笔分类 - Sql练习题
摘要：查询" 01 "课程比" 02 "课程成绩高的学生的信息及课程分数 SELECT sname,sage,class1,class2 from Student, (SELECT t1.sid,t1.class1,t2.class2 from (select sid,cid,score as class
阅读全文
摘要：--学生表 Student create table Student(SId varchar(10),Sname nvarchar(10),Sage date,Ssex varchar(10)); insert into Student values('01' , '赵雷' , '1990-01-0
阅读全文
