Order By语句
select * from lccont order by 'makedate' [asc/desc],'maketime' [asc/desc];
系统日期
select to_char(sysdate-1/24,'yyyyMMddhh24') from dual;
not exists
select e.id from lxxTest_Employee e where not exists(select 1 from lxxTest_wages l where e.id=l.emp_id )
trunc to_char substr
and lc.SIGNDATE = trunc(sysdate)
and substr(lc.signtime,0,2)=to_char(sysdate-1/24,'hh24')