Guest User

Untitled

a guest
Jan 18th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. decode(rslt1,
  2. 'stores',('stores,dead store'),
  3. rslt1);
  4.  
  5. select *
  6. from your_table
  7. where ( ( rslt1 = 'stores'
  8. and rslt = 'dead store')
  9. or rslt = rslt1 )
Add Comment
Please, Sign In to add comment