Çó¸öORACLE SQLÓï¾ä

±í¸ñʽ£º
Col1  col2 
A      11     
B      33     
*      22     

Ä¿µÄ£ºµ±col1 Ϊ A ʱ µÃ³öCOL2ÏàÓ¦µÄÖµ11,µ±col1 Ϊ B ʱ µÃ³öCOL2ÏàÓ¦µÄÖµ33,µ±col2Ϊ D ʱ µÃ³öcol2µÄֵΪ 22£¬±íÖÐÎÞ D Ïà¹ØµÄÊý¾Ý£¬Òò´ËȡͨÓõÄ*µÄÖµ22

---

select col1,col2
  from table_name
where col1='D' or (col1='*' and not exists(
select 1 from table_name b where b.col1='D'
));

---

ÒýÓÃ

select col1,col2
  from table_name
where col1='D' or (col1='*' and not exists(
select 1 from table_name b where b.col1='D'
));

àÅ

---

³ýÁËǶÌ×û±ðµÄ·½·¨Âð£¿
¼ÙÈç
col1 col11 ... ºÃ¶àÁж¼ÊôÓÚÕâÖÖÇé¿ö£¬¾ÍÊÇÈç¹û´æÔÚÔòÑ¡Ôñ´æÔڵģ¬Èç¹û²»´æÔÚ¾ÍÑ¡Ôñ * µÄ¡£ÄÇÆñ²»ÊÇҪǶÌ׺ܶàSQL£¿

---

select col1,col2
  from table_name
where col1 in('D','E','F'.....) or (col1='*' and not exists(
select 1 from table_name b where b.col1 in ('D','E','F'.....)
));

---

ÒýÓÃ

select col1,col2
  from table_name
where col1in('D','E','F'.....)or (col1='*' and not exists(
select 1 from table_name b where b.col1 in('D',