工作中用到过的sql，权当分享给对sql头疼的银儿

select t.*, t.rowid from t_dept_type t 部门
select t.*, t.rowid from t_company t 公司
select t.*, t.rowid from t_employees t 员工

 

select
a.departmentid,
a.userid,
a.datecreated,
a.calltime
from cbssys.DAILPHONE_CALLBACK a
left join cbssys.DAILPHONE_CALLAUTH b
on a.CALLSID=b.ALLCALLSID
where a.compayid='1' order by a.datecreated DESC

select
(select t.dept_type_name from t_dept_type t where t.dept_type_id=a.departmentid),
(select e.emp_name from t_employees e where e.emp_id=a.userid),
a.datecreated,
a.calltime
from cbssys.DAILPHONE_CALLBACK a
left join cbssys.DAILPHONE_CALLAUTH b
on a.CALLSID=b.ALLCALLSID
where a.compayid='1' and a.userid='1' order by a.datecreated DESC

select
(select t.dept_type_name from t_dept_type t where t.dept_type_id=a.departmentid),
(select e.emp_name from t_employees e where e.emp_id=a.userid),
a.datecreated,
a.calltime
from cbssys.DAILPHONE_CALLBACK a
left join cbssys.DAILPHONE_CALLAUTH b
on a.CALLSID=b.ALLCALLSID
where a.compayid='1'
and a.userid='1'
order by a.datecreated DESC
select
(select t.DEPT_TYPE_NAME from T_DEPT_TYPE t where t.DEPT_TYPE_ID=a.DEPARTMENTID) depart,
(select e.EMP_NAME from T_EMPLOYEES e where e.EMP_ID=a.USERID) euser,
a.DATECREATED,
a.CALLTIME
from CBSSYS.DAILPHONE_CALLBACK a
left join CBSSYS.DAILPHONE_CALLAUTH b
on a.CALLSID=b.ALLCALLSID
where a.COMPAYID='1'
order by a.DATECREATED DESC

callRecords cusTell

#{USERID,jdbcType=NUMERIC}