12周代码

最新推荐文章于 2024-08-27 12:09:14 发布

原创最新推荐文章于 2024-08-27 12:09:14 发布 · 720 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#insert #math #c

数据库概论专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了如何使用SQL进行数据插入、更新和查询操作，包括创建表、插入数据、查询数据以及数据分组和筛选等高级功能。通过具体实例展示了SQL在数据管理中的强大能力。

select * from s insert into s(sno, sname, sex, sdept, sage) values('0003','lili',0,'jisuanji',23); insert into s(sno, sname, sex, sdept, sage) values('0004','mao',1,'jisuanji',23); insert into s(sno, sname, sex, sdept, sage) values('0005','deng',0,'xinxi',23); insert into s(sno, sname, sex, sdept, sage) values('0006','rose',0,'xinxi',23); insert into s(sno, sname, sex, sdept, sage) values('0007','kobe',1,'xinxi',23); insert into s(sno, sname, sex, sdept, sage) values('0008','james',1,'cailiao',23); insert into s(sno, sname, sex, sdept, sage) values('0009','wade',0,'cailiao',23); select * from c insert into c(cno, cname, cpno, credit) values('001','math','003',2); insert into c(cno, cname, cpno, credit) values('002','english','004',2); insert into c(cno, cname, cpno, credit) values('003','geography','005',2); insert into c(cno, cname, cpno, credit) values('004','chemitry','006',2); insert into c(cno, cname, cpno, credit) values('005','biology','001',2); insert into c(cno, cname, cpno, credit) values('006','physics','002',2); select * from sc insert into sc(sno, cno, grade) values('0001','001',99); insert into sc(sno, cno, grade) values('0002','002',99); insert into sc(sno, cno, grade) values('0003','003',99); insert into sc(sno, cno, grade) values('0004','004',99); insert into sc(sno, cno, grade) values('0005','001',99); insert into sc(sno, cno, grade) values('0006','002',99); insert into sc(sno, cno, grade) values('0007','002',99); use student select cno, cname from c use student select cno, COUNT(sno) as num from sc group by cno having COUNT(sno) >1 order by num desc, cno asc select sname,sage from s where sex=1 and (sage>= (select AVG(sage) from s where sex=0 ) )