Re: Return the better of two rows based on availablity and preference - NOOB!

From: Barbara Boehmer <baboehme_at_hotmail.com>
Date: 3 Mar 2006 12:15:31 -0800
Message-ID: <1141416931.779906.136970@t39g2000cwt.googlegroups.com>

scott_at_ORA92> SELECT so_arg
  2 FROM (SELECT '1' better, NULL so_arg

  3  	     FROM    dual
  4  	     UNION ALL
  5  	     SELECT '2' better, 'b' so_arg
  6  	     FROM   DUAL
  7  	     ORDER BY better)

  8 WHERE so_arg IS NOT NULL
  9 AND ROWNUM = 1
 10 /

S
-
b

scott_at_ORA92> Received on Fri Mar 03 2006 - 14:15:31 CST