摘要:
select t.C_OPERATE_TIME MODIFY_TIME, t.c_code EMPLOYEE_CODE, t.c_name EMPLOYEE_NAME, CASE t.c_employee_status WHEN '在职' THEN 1 WHEN '实习生' THEN ... 阅读全文
摘要:
判断list if (CollectionUtils.isEmpty(baseStaEmpEntities)) { return;} 判断对象 if (StringUtils.isEmpty(baseStaEmpEntity)) { return;}判断字符串 if (StringUtil.isEm 阅读全文
摘要:
--oracle取前十条数据 --(1)第一种 select * from t_base_employee where rownum < 11; --(2)第二种 select * from (select * from t_base_employee t order by t.modify_time desc) where rownum <= 10; 阅读全文
摘要:
date类型 select * from t_base_employee t where t.modify_time>to_date('2018-06-28 00:00:00','yyyy-mm-dd hh24:mi:ss') and t.modify_time<to_date('2018-06-2 阅读全文