几道sql题求答案

发布网友发布时间：2023-06-10 11:03

共2个回答

热心网友时间：2024-10-16 02:02

1，select * from 表名 order by 姓名
2，select * from 表面 where 课程=“数据结构” and 姓名 like “%李%”
3，select max(成绩），min(成绩)，avg(成绩) from 表名 group by 成绩
4,select into 男学生表 from 表名 where 性别=“男”
5,select * from 表名 where 性别=“女” and 年龄>20
6,create uniwue clustered index i_name on 表名（s_name）
7,create nonclustered index i_score on 表名(score)
8,create view v_nopass as select 学号，姓名，科目，成绩 where 成绩<60

热心网友时间：2024-10-16 02:02

1、select * from student order by sname desc;
2、select * from student a,course b where a.sid=b.sid and b.name='数据结构' and a.sname like '李%';
3、select max(score) from score group by name
4、create table 男学生表 as select * from student where sex='m';
5、select * from student where age>'20' and sex='w';
6、create unique index i_name on Student(s_name desc);
7、create index i_score on score(score asc);
8、create view v_nopass select * from student a,score b wehre a.id=b.id and b.score<60;