请教一道SAS ADV认证的题目

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

59. Given the following SAS program:

proc sql;

select name, salary, birthdate

from employee

where 500 = (select amount from sales where employee.name = sales.name);

quit;

Which SQL procedure program produces the same output?

A. proc sql;

select sales.name, salary, birthdate

from employee, sales

where employee.name = sales.name and amount = 500; quit;

B. proc sql;

select name, salary, birthdate

from employee

where select amount from sales

where employee.name = sales.name = 500;

quit;

C. proc sql;

select name, salary, birthdate

from employee, sales

where name = name and amount = 500;

quit;

D. proc sql;

select (select sales.name from sales where amount = 500), salary, birthdate

from employee

where employee.name = sales.name;

quit;

我想问问为什么不能选D。我用SAS跑了一下程序得到提示“ERROR: Unresolved reference to table/correlation name sales.
”，可是不知到为什么不行。

谢谢~~

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：correlation Reference Procedure following Employee 认证

选A吧，其它3个选项语法不对。

select (select sales.name from sales where amount = 500), salary, birthdate
要改为
select * from  (select sales.name from sales where amount = 500)
这种类型才对，select后不能接select语句。

bjpucl 发表于 2014-2-24 16:14
选A吧，其它3个选项语法不对。

select (select sales.name from sales where amount = 500), salary, bi ...

看懂了，谢谢

谢谢！学习了