写过的sql语句

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')