数据库sql查询语句
发布网友
发布时间：2022-04-25 21:42
共4个回答
热心网友
时间：2022-04-08 22:25
studentnub,age
from
student
where
sex
="男"
2、select
coursenum,teachername
from
course
where
coursename
="数据库系统概论"
3、select
studentnum,studentname
from
student
where
studentnum=(select
studentnum
from
SC
where
score>80)4.update
student
set
grade=grade+10
where
coursename='计算机技术系'
热心网友
时间：2022-04-08 23:43
学号、年龄
from
student
2.select
课程号、授课老师
from
course
where
课程=‘数据库系统概论’
3.select
*
from
student
where
分数>80
4.update
student
set
成绩=成绩+10
where
所学的系='计算机技术系'
热心网友
时间：2022-04-09 01:18
studentnub,age
from
student
where
sex
="男"
2、select
coursenum,teachername
from
course
where
coursename
="数据库系统概论"
3、select
studentnum,studentname
from
student
where
studentnum=(select
studentnum
from
SC
where
score>80)
热心网友
时间：2022-04-09 03:09
from
student
where
性别='男生'
select
课程号,授课教师
from
course
where
课程='数据库系统概论'
