当列列中的条件满足时，如何编写oracle查询。 [英] how to write oracle query when conditon in column vale satisfies.

问题描述

如果当列的条件满足时我怎么能写oracle查询那么应该从另一个表中获取值





例如< br $>




选择ename，enmae，

case当loc ='zyz'然后

从pincode中选择定位引脚，其中pincodeno ='zyz'

结束

来自emp;



谢谢提前

解决方案

我想你正在寻找EXISTS [ ^ ]语句。

  SELECT  ename，enmae 
  FROM  \\ temp  WHERE   EXISTS （ SELECT  [location pin]  FROM  pincode  WHERE  pincodeno = '  xyz'  AND  emp.loc = pincode.pincodeno）; 

Hi how can i write oracle query when conditon of column satisfies then value should be take from another table


for eg


select ename,enmae,
case when loc='zyz' then
select location pin from pincode where pincodeno='zyz'
end
from emp;

Thanks in advance

解决方案

I think you're looking for EXISTS[^] statement.

SELECT ename, enmae
FROM emp WHERE EXISTS(SELECT [location pin] FROM pincode WHERE pincodeno='xyz' AND emp.loc=pincode.pincodeno);

这篇关于当列列中的条件满足时，如何编写oracle查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！