need Oracle code logic
916628Feb 9 2012 — edited Feb 12 2012i have a single row sub query which returns row with del_flag as N. Now in my db, there are 2 rows getting added from the incoming feed with del_flag as Y & N.
So how can i modify the query to return the row with del_flag as N. if there is no row with del_flag as N, it should return the row with del_flag as Y.
Could some one help me on this.