|
ACS3 Data Model |
||||||||||||
| |||||||||||||
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|---|---|---|---|---|---|
| USER_ID | NUMBER(38) | Y | NO | NO | NO | |
| SALARY | NUMBER(38) | Y | NO | NO | NO |
select user_id, round(salary * 12) as salary from im_employee_info where salary_period = 'month' union select user_id, salary from im_employee_info where salary_period = 'year'