select stu_code,stu_name,class_code from student where stu_name like '刘%';
select stu_name,stu_weight,stu_birthday from student where to_char(stu_birthday,'yyyymmdd')>19980212;
select stu_name,stu_weight,class_code from student where (class_code=3 or class_code=2) and stu_weight>50;
select a.* from (select stu_name,class_code,stu_weight from student order by 3 asc) a where rownum<=1;
select a.stu_code,a.stu_name,b.cl_name,b.cl_major from student a,class b where a.class_code=b.cl_code;
select stu_name,stu_weight,stu_birthday from student where to_char(stu_birthday,'yyyymmdd')>19980212;
select stu_name,stu_weight,class_code from student where (class_code=3 or class_code=2) and stu_weight>50;
select a.* from (select stu_name,class_code,stu_weight from student order by 3 asc) a where rownum<=1;
select a.stu_code,a.stu_name,b.cl_name,b.cl_major from student a,class b where a.class_code=b.cl_code;