求数据库原理题 答案 题目如下 尽快
发布网友
发布时间：2022-04-27 04:43
共1个回答
热心网友
时间：2022-06-26 10:01
1)select chenji from biao where chenji< (select avg(chengji) from biao)
2)select xuehao,chengji from biao where kechenghao like 'C135' order by xuehao asc
3)update biao set chengji=chengji+5 where chengji<60
4)select xuehao,chengji from biao where kechenghao like 'c135' and chengji <(select avg(chengji) from biao)
5)select xuehao from (select * from biao where kechenghao='C135') where kechenghao in ('C219')
先写到这里，回复见下文追问i‘m so sorry 他们都不是一个表的 我的错
