2006-6-20 10:57
stevenyip
新手求教。。
There are four coding errors in this statement. Can you identify them?
SELECT employee_id, last_name
sal x 12 ANNUAL SALARY
FROM employees;
这段语句怎么修改?
谢谢
2006-6-20 14:33
SunnyXu
SELECT employee_id, last_name
sal x 12 "ANNUAL SALARY"
FROM employees;
2006-6-20 15:42
stevenyip
:'(:'(ths!!!
2006-6-20 15:44
stevenyip
sal * 12 "ANNUAL SALARY"
*
ERROR 位于第 2 行:
ORA-00923: 未找到预期 FROM 关键字
报错阿。。。
2006-6-20 16:04
charly
SELECT employee_id, last_name ,
sal*12 "ANNUAL SALARY"
FROM employees;
可以吗?
2006-6-20 16:13
stevenyip
SELECT employee_id, last_name,
SALARY*12 "ANNUAL SALARY" FROM employees;
可以了。。。谢谢啊!!!:'(:'(:victory::kiss:
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.