CSI 考前帖!

[bbrother_bbrothe]

最初由 点着看 发布
(D)要用distinct去除重复的行吧
还有，如果列名或表名里有空格，列名或表名要用引号包起来

我看不懂。。。不会改，你看看能不能帮我该了

 

[点着看]

(D)Select distinct "department name"
From E,D,EP
Where "project number"=467 and
E."department number"= D."department number" and
E."employee number"= EP."employee number"；

这个我确定是在oracle和sql server里能运行的

 

[bbrother_bbrothe]

最初由 点着看 发布
(D)Select distinct "department name"
From E,D,EP
Where "project number"=467 and
E."department number"= D."department number" and
E."employee number"= EP."employee number"；

这个我确定是在oracle和sql server里能运行的

欧可，谢啦。

 

[bbrother_bbrothe]

最初由 bbrother_bbrothe 发布
(C)Select employee name
From E and EP
Where E.employee number= EP.employee number；


(D)Select department name
From E,D,EP
Where project number=467 and
E.department number= D.department number and
E.employee number= EP.employee number；


PS: E，D,P,EP,分别是table employee,department, project, employee& project

Thanks to 点着看，我把我这个改一下，下面的D是正确的
(D)Select distinct "department name"
From E,D,EP
Where "project number"=467 and
E."department number"= D."department number" and
E."employee number"= EP."employee number"；

 

[bbrother_bbrothe]

ONE QUESTION: 好像不用加引号，我看SLIDE里面没有引号

 

[点着看]

在sql里有个给列和表起别名的功能，比如说
Select D."Department name" DP
From Department D;
就是把表Department起了个别名D，列Department Name起了个别名DP
而真实的列名和别名之间是靠AS或者空格分开的
也就是说，如果列名或者表名里有空格，后半部分会被认为是别名

最初由 bbrother_bbrothe 发布
ONE QUESTION: 好像不用加引号，我看SLIDE里面没有引号

 

[黎明的铜镜中]

:flaming: :flaming:

 

[点着看]

sorry,长时间不用，东西都忘了，应该是用方括号把字段名括起来
Select distinct [department name]
From E,D,EP
Where [project number]=467 and
E.[department number]= D.[department number] and
E.[employee number]= EP.[employee number]；

最初由 bbrother_bbrothe 发布


Thanks to 点着看，我把我这个改一下，下面的D是正确的
(D)Select distinct "department name"
From E,D,EP
Where "project number"=467 and
E."department number"= D."department number" and
E."employee number"= EP."employee number"；

 

[great_day]

天呢　越看越没信心了！

 

[great_day]

which one is correct? confusing now!

 

[空]

最初由 bbrother_bbrothe 发布
我明天晚上10点考完psychology，然后我要没死的话就回来贴。
我现在贴先贴选择。
1-5 D E C A B
6-10 B A C E D

g(第7题)是e吧？因为它说的是from Excel worksheet into Word doc啊？不是from Excel worksheet to another Excel worksheet哦
真的可以embed过去么？

 

[great_day]

楼上的照片里是谁啊 ? 美女啊! 呵呵 看美女 比看CSI开心多了 哈哈

 

[bbrother_bbrothe]

1(g) If I ____________ an Excel worksheet into a Word document, I can change a formula in the worksheet in the Word document without changing the formula in the source Excel worksheet.
(a) embed
(b) paste
(c) cut
(d) link
(e) none of the above; it is impossible

答案是 a。。可以过去embed过。

Reference: Powerpoint06_excel 2, Slide 31
Result
The name of the program that created that object is embedded along with the transferred information
In the destination document, the transferred information will have a box around it
The destination program cannot edit the information
Double clicking on the object brings the program that created the object to the screen so that the object can be edited
Advantage
The functionality of the source program is retained
However, the embedded information is not linked to the source information

 

[空]

最初由 great_day 发布
楼上的照片里是谁啊 ? 美女啊! 呵呵 看美女 比看CSI开心多了 哈哈

呵呵，不是我

 

[空]

最初由 bbrother_bbrothe 发布
1(g) If I ____________ an Excel worksheet into a Word document, I can change a formula in the worksheet in the Word document without changing the formula in the source Excel worksheet.
(a) embed
(b) paste
(c) cut
(d) link
(e) none of the above; it is impossible

答案是 a。。可以过去embed过。

Reference: Powerpoint06_excel 2, Slide 31
Result
The name of the program that created that object is embedded along with the transferred information
In the destination document, the transferred information will have a box around it
The destination program cannot edit the information
Double clicking on the object brings the program that created the object to the screen so that the object can be edited
Advantage
The functionality of the source program is retained
However, the embedded information is not linked to the source information

哦这样啊~