SQL语句如下:
with t as (select * from emp where depno=10)
select * from t where empno=xxx如果将它整个放到<select> </select>里面是不对的
求助,如何写呢?谢谢!!!
with t as (select * from emp where depno=10)
select * from t where empno=xxx如果将它整个放到<select> </select>里面是不对的
求助,如何写呢?谢谢!!!
这样写太长了。
把这个SQL封装成视图create view vvv as
with t as (select * from emp where depno=10)
select * from t
ibatis里面 select * from vvv where empno=xxx
with t as (select * from emp where depno=10)
select * from t where empno=xxx
</sql>
然后再select 中引用不就行了吗