LoveUnix » ORACLE等数据库 » 新手求教。。
让LU留住您的每

一天 让LU博客留住您的每一天
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.