|
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, salary/12 as salary from im_employee_info where salary_period = 'year' union select user_id, salary from im_employee_info where salary_period = 'month'