String sql = "select * from (select USER_ID,USER_NAME,FACEADDRESS,rownum as no FROM ((SELECT STUDENT_ID USER_ID,STUDENT_NAME USER_NAME,FACEADDRESS FROM XTGL_STUDENT WHERE student_name LIKE ? OR STUDENT_ID LIKE ? ) UNION(SELECT TEACHER_ID USER_ID,TEACHER_NAME USER_NAME,FACEADDRESS from XTGL_TEACHER WHERE TEACHER_NAME LIKE ? OR TEACHER_NAME LIKE ? )) )x WHERE (x.no <= "String sql = "select * from (select USER_ID,