代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/185834/8982098
sql 11.sql
use student_class
select *
from course
where ccredit between 2.0 and 4.0
www.eeworm.com/read/185834/8982101
sql 3.sql
use student_class
create table SC
(sclass varchar(2),--班级
sno varchar(2),--编号
cno varchar(3),--课程号
grade real check(grade=0.0), --成绩
primary key(sclass,sno,cno),
foreign key (
www.eeworm.com/read/185834/8982105
sql 17.sql
select *
from student
where exists
(
select *
from sc
where cno in
(
select cno
from sc
where sclass='1'and sno='2'
) and sno=student.sno and sclass=student.sclass
)
www.eeworm.com/read/185834/8982109
sql 19.sql
select student.*,sc. grade
from student,sc
where student.sno in(select sno from sc where sclass=1
group by sno
having(avg(grade)>85))
and sc.sno=student.sno and student.scla
www.eeworm.com/read/185834/8982112
sql 12.sql
use student_class
select distinct student.* --用distinc去重
from student ,sc
where student.sclass=sc.sclass and student.sno=sc.sno
and cno in('1','2')
www.eeworm.com/read/185834/8982117
sql 9.sql
use student_class
select cno ,cname
from course
where cpno is null--不能用=null
www.eeworm.com/read/185834/8982120
sql 8.sql
use student_class
select sname,ssex,grade
from student,sc
where student.sclass=sc.sclass and student.sno=sc.sno
and cno='1'
www.eeworm.com/read/185834/8982125
sql 22.sql
select sclass,sno from sc
where cno=1 and sno not in(select sno from sc where cno=2)
www.eeworm.com/read/185834/8982129
sql 18.sql
select *
from student
where not exists
(
select *
from sc
where sno=student.sno and cno='1'and sclass=student.sclass
)