说明:工号:employee_id, 部门id: dept_id, 改变时间:change_time 你所查询月的起始时间:begin_time, 你所查询月的结束时间:last_time, 表名:table_nameselect employee_id,change_time from table_time where to_char(change_time) between begin_time and last_time order by change_time;
你所想要查询的部门:think_dept 如果要控制到部门的话就再在 where 句中加上 and dept_id='think_dept'
你所查询月的起始时间:begin_time,
你所查询月的结束时间:last_time,
表名:table_nameselect employee_id,change_time
from table_time
where to_char(change_time) between begin_time and last_time
order by change_time;
如果要控制到部门的话就再在 where 句中加上
and dept_id='think_dept'