sql笔试及答案大全
@袁中3644：sql笔试题 -
丰沾15352382828…… 两个表第一个store(store_id,city,space)第二个employee(store_id,emp_id,salary)1、每家店的平均工资 select t1.store_id,AVG(salary) from store t1 inner join employee t2 on t1.store_id=t2.store_...
@袁中3644：sql server 笔试题,求答案,急!!!!!!!!!!!!!! -
丰沾15352382828…… 这套笔试题你想拿上100分,也该悬赏上100分. 输上基本上都有答案,看看SQL2005的书 create database STU --创建数据库 use login1 go create table STUDENT --建表 ( SNO char(10) primary key, SNAME varchar(8), SEX char(2) default 男,--默认值为男,只能输入男或女 SAGE int, SDEPT VARCHAR(20) ) 别的表类似.
@袁中3644：SQL试题—— 跪求师哥师姐给个答案 如果可以的话 再给个讲解 师弟再次谢谢了有三个表:学生表Student、课程表Course和选课表SC.如下表所示Student ... - 作业帮
丰沾15352382828…… [答案] 1) Select Sno,Cno From SC Where Sno Not In(Select Sno From SC Where Grade>=60 Group By Sno)----第1括号中表示按学号分组,并找出所有成绩>=60的学生学号.一般求及格或不及格的这种类型,我们先找相反的(即如...
@袁中3644：SQL试题 200分!!! -
丰沾15352382828…… 1. select s.sname,sc.scgrade from s,sc where s.sno=sc.sno and cno='1'2.select s.sname from s,c,sc where s.sno=sc.sno and c.cno= sc.cno and cteacher='李明'3.select sum(sc.scgrade)/count(sc.scgrade),s.sname from s,sc where s.sno=sc.sno ...
@袁中3644：SQL笔试题 -
丰沾15352382828…… 一般不用一句话写 数据部分 select date, sum(num) as num from table group by date 合计部分 select sum(num) as sum from table 如果非要和在一起显示只能这样 select date, sum(num) as num from table group by date union selec '合计' as date, ...
@袁中3644：大学计算机SQL查询考试题!急求答案!好的话再加分! -
丰沾15352382828…… (1)select avg(成绩) from 表 where sex = '女' (2)select 课程号,课程名,学生姓名,成绩,任课教师 from 表 where 选修课程名='基础会计' (3)select 姓名,年龄,性别 from 表 where 学号 like '11%' (4)select 微观经济学,count(微观经济学)...
@袁中3644：SQL 疑难笔试题 -
丰沾15352382828…… 1.select max(infoID)+1-min(infoID)-count(infoID) from Info 2. declare @id int, select @id=min(infoID) from Info declare @ckid int declare ID_cursor cursor for select infoID from Info open ID_cursor fetch from ID_cursor into @ckid while @@fetch_...
@袁中3644：SQL语句,试题 -
丰沾15352382828…… 题1:请查询姓名与手机重复的记录 SELECT * FROM 观众资料登记表 a WHERE [姓名]+[手机] IN (SELECT [姓名]+[手机] FROM 观众资料登记表 b GROUP BY [姓名],[手机] HAVING COUNT(*)>1) 题2:请查询一个单位名称有不同编号记录 ...
@袁中3644：SQL数据库笔试题 -
丰沾15352382828…… select * from student where s_id in ( select s_id from xuanke group by s_id having count(c_id) >2)
丰沾15352382828…… 两个表第一个store(store_id,city,space)第二个employee(store_id,emp_id,salary)1、每家店的平均工资 select t1.store_id,AVG(salary) from store t1 inner join employee t2 on t1.store_id=t2.store_...
@袁中3644：sql server 笔试题,求答案,急!!!!!!!!!!!!!! -
丰沾15352382828…… 这套笔试题你想拿上100分,也该悬赏上100分. 输上基本上都有答案,看看SQL2005的书 create database STU --创建数据库 use login1 go create table STUDENT --建表 ( SNO char(10) primary key, SNAME varchar(8), SEX char(2) default 男,--默认值为男,只能输入男或女 SAGE int, SDEPT VARCHAR(20) ) 别的表类似.
@袁中3644：SQL试题—— 跪求师哥师姐给个答案 如果可以的话 再给个讲解 师弟再次谢谢了有三个表:学生表Student、课程表Course和选课表SC.如下表所示Student ... - 作业帮
丰沾15352382828…… [答案] 1) Select Sno,Cno From SC Where Sno Not In(Select Sno From SC Where Grade>=60 Group By Sno)----第1括号中表示按学号分组,并找出所有成绩>=60的学生学号.一般求及格或不及格的这种类型,我们先找相反的(即如...
@袁中3644：SQL试题 200分!!! -
丰沾15352382828…… 1. select s.sname,sc.scgrade from s,sc where s.sno=sc.sno and cno='1'2.select s.sname from s,c,sc where s.sno=sc.sno and c.cno= sc.cno and cteacher='李明'3.select sum(sc.scgrade)/count(sc.scgrade),s.sname from s,sc where s.sno=sc.sno ...
@袁中3644：SQL笔试题 -
丰沾15352382828…… 一般不用一句话写 数据部分 select date, sum(num) as num from table group by date 合计部分 select sum(num) as sum from table 如果非要和在一起显示只能这样 select date, sum(num) as num from table group by date union selec '合计' as date, ...
@袁中3644：大学计算机SQL查询考试题!急求答案!好的话再加分! -
丰沾15352382828…… (1)select avg(成绩) from 表 where sex = '女' (2)select 课程号,课程名,学生姓名,成绩,任课教师 from 表 where 选修课程名='基础会计' (3)select 姓名,年龄,性别 from 表 where 学号 like '11%' (4)select 微观经济学,count(微观经济学)...
@袁中3644：SQL 疑难笔试题 -
丰沾15352382828…… 1.select max(infoID)+1-min(infoID)-count(infoID) from Info 2. declare @id int, select @id=min(infoID) from Info declare @ckid int declare ID_cursor cursor for select infoID from Info open ID_cursor fetch from ID_cursor into @ckid while @@fetch_...
@袁中3644：SQL语句,试题 -
丰沾15352382828…… 题1:请查询姓名与手机重复的记录 SELECT * FROM 观众资料登记表 a WHERE [姓名]+[手机] IN (SELECT [姓名]+[手机] FROM 观众资料登记表 b GROUP BY [姓名],[手机] HAVING COUNT(*)>1) 题2:请查询一个单位名称有不同编号记录 ...
@袁中3644：SQL数据库笔试题 -
丰沾15352382828…… select * from student where s_id in ( select s_id from xuanke group by s_id having count(c_id) >2)
