sql语句的问题

提示缺少关键字，哪点写错了吗？求指点

select loginname,realname,qd,
(case
when substr(qt,0,10)=to_char(to_date(qd,'yyyy-mm-dd')+1,'yyyy-mm-dd') then qt=substr(qd,0,10)||' 00:00:00'
when substr(qt,0,10)>to_char(to_date(qd,'yyyy-mm-dd')+1,'yyyy-mm-dd') then qt=qd
else qt end) as qt from
(
select loginname,realname,qt,qd
from (
select loginname,realname,qt ,max(qd) qd  from (
select loginname,realname,qd,min(qt) qt from (
select qdl.loginname,qdl.realname,qdl.qd,qtl.qt from
(select a.loginname,a.realname,b.create_time as qd
from sys_user a
left join call_in_out_count b
on a.loginname = b.loginname
where a.userid in (select USERID from sys_user_role where ROLEID in (146,306))
and b.type = 1
order by b.create_time) qdl
left join (
select a.loginname,a.realname,b.create_time as qt
from sys_user a
left join call_in_out_count b
on a.loginname = b.loginname
where a.userid in (select USERID from sys_user_role where ROLEID in (146,306))
and b.type = 2
order by b.create_time) qtl
on qdl.loginname=qtl.loginname
and qtl.qt>qdl.qd
order by qd asc,qt asc)
group by loginname,realname,qd
order by qd asc)
group by loginname,realname,qt
order by qt)

)
;

FineReport回音无痕 发布于 2018-8-3 13:43

关注问题

悬赏：2 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共4回答

最佳回答