oracle单行子查询返回多个行

[qq_28391909]

select count(datetime) from attence w where exists
((select * from attence where to_char(w.datetime,'yyyy/mm/dd') = to_char(w.datetime,'yyyy/mm/dd'))
)and to_date((select gotime from attence),'HH24:MI:SS') > to_date((select gostandertime from standertime ),'HH24:MI:SS')
and to_date((select gotime from attence),'HH24:MI:SS') < to_date((select nulltime from standertime),'HH24:MI:SS') and usernumber=1;

[卖水果的net]

-- 应该是这句的问题
select gotime from attence
-- 如果你的这张表只有这两条数据话，可以加个 max 
select max(gotime) from attence

[mayanzs]

可在子查询上加 any