1、有个表tableQQ,有整型的ID项和字符类型的Nickname项,这两个项都不允许为空
(1)写出建立该表的SQL语句
(2)找出Nickname为QQ的用户,按ID降序排列的SQL语句
(3)写出删除ID为1234用户记录的SQL语句
(4)写出添加ID为5555,Nickname为'1234'的SQL语句
答案: (1) CREATE TABLE tableQQ
( ID NUMBER(12) NOT NULL,
Nickname Varchar2(30) NOT NULL );
(2) select * from tableQQ where Nickname = 'QQ' order by ID desc;
(3) delete from tableQQ where ID='1234';
(4) insert into tableQQ values(5555,'1234');
//删除表
(5)drop table tableQQ
2、有关系 s(sno,sname) c(cno,cname) sc(sno,cno,grade)
1 )、问上课程 "db"的学生
2)、 成绩最高的学生号
3 )、每科大于90分的人数
答案: (1)select a.sno, a.cno, b.cno, b.cname
from sc a, c b
where a.cno = b.cno and b.cname = 'db';
(2)select sno, max(grade)from sc group by sno;
(3)select cno, count(sno) from sc where grade > 90 group by cno;