关于一个Oraclesql的问题!在线等,急!!顶者有分!
颓废的老猫 2006-06-26 10:42:48 下面的这条SQL语句可以查出结果,VIEW_EMPLOYINFO3是一个视图
"SELECT * FROM (SELECT ROWNUM AS ADODB_ROWNUM,COMPANYNAME FROM jy_user.VIEW_EMPLOYINFO3 where 1=1 and and ROWNUM <= 20 ORDER BY ISSUEDATE DESC) WHERE ADODB_ROWNUM > 0";
如果在上面的语句的子查询里面加一个条件“and WORKDESCRIBE like '%力%'”就查不出结果,什么原因啊?
加过之后语句如下:
"SELECT * FROM (SELECT ROWNUM AS ADODB_ROWNUM,COMPANYNAME FROM jy_user.VIEW_EMPLOYINFO3 where 1=1 and WORKDESCRIBE like '%力%' and ROWNUM <= 20 ORDER BY ISSUEDATE DESC) WHERE ADODB_ROWNUM > 0";
急!!!
另外哪里有Oracle客户端下载啊?