一个做BI公司的数据库面试题，有兴趣的朋友可以来做了试下？有一定难度，可以来挑战下(50分)

浪

浪人情哥

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-03

• #21

其实第三题是不合格的,因为学科写死了,可是不用变量,不用游标.......

 

X

xingxin00

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-03

• #22

lzh1983，很强，我运行了，利用查询分析器验证了，完全正确，顶一下。强！强！强！强！强！强！[]

 

Z

zlibo2008

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-03

• #23

lzh1983的第一题就不对,查出来的是没有参加任何考试的人的课程,其余两题没看<br>不知楼上的为什么会认为完全正确

 

浪

浪人情哥

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-03

• #24

呵呵，不知道楼上的你为什么看不懂你楼上的

 

M

mokmok

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-04

• #25

其实这里有一个关键就是对于<br>Lession(lessions nvarchar(50),score int) &nbsp;获得任意的所有学科的前几名,其实只要对每一个科的分数给它排一个序就完事了 代码如下<br>select &nbsp;Liessions,Score,(select count(*) from <br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (select distinct * From Lession)xx <br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Where &nbsp; &nbsp;xx.Liessions=yy.Liessions <br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;And &nbsp; xx.Score&gt;=yy.Score) as tmd<br>From(select distinct Liessions,Score From T_Score) yy

 

N

necyhk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-04

• #26

oracle的语句怎么没什么人来写呀

 

浪

浪人情哥

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-04

• #27

Oracle的很简单啊，我都没有兴趣去写了

 

N

necyhk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-04

• #28

结贴了，

 

G

gaobangsheng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-09

• #29

/* &nbsp;--第一題<br>select Stu_Name, Class_id,Lession_Name<br>from T_Lession, T_Stu_Profile<br>where not Exists (select * from T_Score where Stu_id = T_Stu_Profile.Stu_id and Lession_id = T_Lession.Lession_id )<br>order by Stu_id<br>*/