基于oracle数据库的查询（在jsp中listtable列表）

[zgy_yj]

求助啊，各位大牛，下面是我的
[09-15 21:49:58] [oakq] [debug]: (class com.ds.dblib.core.FormatSQL) [dblib] removeSelectOrderBy :SELECT (SELECT id FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT user_id FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_number FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT user_name FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_time FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_state FROM t_oa_attendance_manage WHERE user_name='考勤管理') FROM t_oa_attendance_manage a WHERE 1=1 ORDER BY a.attendance_number ASC
[09-15 21:49:58] [oakq] [debug]: (class com.ds.dblib.core.FormatSQL) [dblib] getCountSql :SELECT (SELECT id FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT user_id FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_number FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT user_name FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_time FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_state FROM t_oa_attendance_manage WHERE user_name='考勤管理') FROM t_oa_attendance_manage a WHERE 1=1
[09-15 21:49:58] [oakq] [debug]: (class com.ds.dblib.core.DBManager) [dblib] getQuerySQL sql : SELECT * FROM ( SELECT ROW_.*, ROWNUM rn_ FROM ( SELECT (SELECT id FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT user_id FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_number FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT user_name FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_time FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_state FROM t_oa_attendance_manage WHERE user_name='考勤管理') FROM t_oa_attendance_manage a WHERE 1=1 ORDER BY a.attendance_number ASC ) ROW_ WHERE ROWNUM <= 15) WHERE rn_ > 0
[09-15 21:49:58] [oakq] [error]: (class com.ds.dblib.core.DBManager) [dblib] executeQueryEx Exception Error : SELECT (SELECT id FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT user_id FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_number FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT user_name FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_time FROM t_oa_attendance_manage WHERE user_name='考勤管理'),(SELECT attendance_state FROM t_oa_attendance_manage WHERE user_name='考勤管理') FROM t_oa_attendance_manage a WHERE 1=1 ORDER BY a.attendance_number ASCjava.sql.SQLException: ORA-01427: 单行子查询返回多个行

[卖水果的net]

把这些子查询逐个排查一下，看看哪个出了问题，把它找出来，再结合业务分析一下，两行（或多行）要哪一行。

[碧水幽幽泉]

SQL语句改下就行了：
select id,user_id, attendance_number,user_name,attendance_time,attendance_state
from t_oa_attendance_manage
where user_name='考勤管理'
order by attendance_number;

select *
from(select id,user_id,attendance_number,user_name,attendance_time,attendance_state
from t_oa_attendance_manage
where user_name='考勤管理'
order by attendance_number
)
where rownum <= 15