k****t 发帖数: 12697 | 1 用不这这复杂, 俺老头子的解:
select p1.name, p2.name, score from
scores s inner join people p1
on s.id1=p1.idnumber
inner join people p2
on s.id2=p2.idnumber
where p1.name='chuck' and p2.name='john'
or p2.name='chuck' and p1.name='john'
包子啊 |
|
k****t 发帖数: 12697 | 2 吃
select p1.name, p2.name, score from
scores s join people p1
on s.id1=p1.idnumber
join people p2
on s.id2=p2.idnumber
where p1.name='chuck' or p2.name='chuck' |
|
s********h 发帖数: 286 | 3 一个很简单的 stream input 小程序,目的是读入名字,ID号码,及其它信息。
我的问题是,如果先读入名字,再读入 ID,就一切正常,可是如果先读入 ID,在读名
字的时候,就会自动跳过,不让我输入名字了。我的程序如下:
#include
using namespace std;
int main()
{
unsigned idNumber;
char firstName[30];
int hoursWorked;
char ch = '\0';
int i = 0;
cout << "Please enter your first name: ";
while (1) {
cin.get(ch);
if (ch == '\n') break;
firstName[i++] = ch;
}
firstName[i] = '\0';
cout << "Please enter your ID Number: ";
cin >> idNumber;
cout |
|
j*****a 发帖数: 436 | 4 把 cout << endl;换成 cin.get();
因为cin >> idNumber;中idNumber只接受了数字,而把"\n"符剩下了。 |
|
发帖数: 1 | 5 他说的那个number是可以代替ssn的,我也记得是有什么idnumber可以代替ssn的
但是多数资费f1都没有收入 |
|
s*********d 发帖数: 2406 | 6 只同意出certification of employment |
|
|
|
c****p 发帖数: 6474 | 9 certification of employment上应该有everify number的。 |
|
j*********g 发帖数: 324 | 10 CVS好像和rite aid系统一样。都是用nexgen。我们Rite aid刚来了一个绿墙转过来的
,说是nexgen比绿墙的好用些。楼上BIBO说的bluecross那个保险是很讨厌,他们4月1
号退出medco之后,IDnumber后面一定要输入01(cardholder),或02.。。。有时候
cardholder要输51,或是53.。。反正有些乱。记得4月初的时候,因为这个改动,搞得
很麻烦,有些是电脑自动改,有些不是,每次还要病人拿新的insurance card过来。。
。。
我也是觉得insurance比较难搞定,这些学校又不交的。药剂师也就说这个需要经验。
但是还是希望有哪位前辈能够总结一下 |
|
t*****2 发帖数: 94 | 11 ods csvall file='c:\test.cvs';
proc print data=work.one;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
what is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any
text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by SAS.
在网上搜了半天还是没有得到确定的答案。请各位高手赐教! |
|
t*****2 发帖数: 94 | 12 ods csvall file='c:\test.cvs';
proc print data=work.one;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
what is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any
text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by SAS.
在网上搜了半天还是没有得到确定的答案。请各位高手赐教! |
|
p***7 发帖数: 535 | 13 another one:
45.The following SAS program is submitted:
ods csvall file=’c:\test.cvs’;
proc print data=WORK.ONE;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
What is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any
text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by... 阅读全帖 |
|
x*c 发帖数: 156 | 14 45.The following SAS program is submitted:
ods csvall file='c:\test.cvs';
proc print data=WORK.ONE;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
What is produced as output?
A. A file named test.cvs that can only be opened in Excel.
B. A text file named test.cvs that can be opened in Excel or in any
text editor.
C. A text file named test.cvs that can only be opened in a text editor.
D. A file named test.cvs that can only be opened by SAS
70题里的答案是C, crakm... 阅读全帖 |
|
i*t 发帖数: 835 | 15 以前看人讨论过,今天考到了,发现和大家手上的70题有点不一样。大家考试准备的时
候可以注意。一个是45.The following SAS program is submitted:
ods csvall file='c:\test.cvs';
proc print data=WORK.ONE;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
What is produced as output?
我见到的是ods csvall file='c:\test.csv';
29.The following SAS program is sumbitted:
data WORK.INFO;
infile 'DATAFILE.TXT';
input @1 Company $20. @25 State $2. @;
if State=' ' then input @30 Year;
else input @30 City Year;
inp... 阅读全帖 |
|