代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/185834/8982061
sql 16.sql
use student_class
select student.*
from student,sc
where student.sclass=sc.sclass and student.sno=sc.sno
and cno='2' and grade>any
(
select grade
from sc ,student
where cno='2'and
student.
www.eeworm.com/read/185834/8982065
sql 23.sql
select sname, grade from sc,student
where cno=2 and student.sno=sc.sno and student.sclass=sc.sclass
and student.sno in(select sno from sc where cno=2)
order by grade desc
www.eeworm.com/read/185834/8982068
sql 7.sql
use student_class
select *
from Student
where sname like'刘%'
www.eeworm.com/read/185834/8982071
sql 10.sql
use student_class
select *
from student
where sclass='2'and ssex='Ů'
www.eeworm.com/read/185834/8982075
sql 2.sql
use student_class
create table Student
(
sclass varchar(2),--班级
sno varchar(2),--学号
sname varchar(10) not null,--姓名
ssex varchar(2) check(ssex in('男','女')),--性别,将性别限制为男女
sage int ,--年龄
sdept v
www.eeworm.com/read/185834/8982079
sql 5.sql
use student_class
select sno,sname
from student
where sclass='1'
www.eeworm.com/read/185834/8982083
sql 1.sql
create table Course
(cno varchar(3),--课号
cname varchar(20) not null,--课名
cpno varchar(3),--先行课
ccredit real ,--学分
primary key(cno)--设置主键
)
insert into Course(Cno,Cname,Cpno,Ccredit)
values(1,'
www.eeworm.com/read/185834/8982087
sql 20.sql
use student_class
select distinct student.sclass ,student.sno
from student ,sc x,sc y
where student.sclass=x.sclass and student.sno=x.sno
and x.cno='1'and y.sclass=x.sclass and y.sno=x.sno and
y.
www.eeworm.com/read/185834/8982095
sql 15.sql
use student_class
select student.*
from student,sc
where student.sclass=sc.sclass and student.sno=sc.sno
and sc.sclass='1'and cno='2' and grade