Re: How to include an IF() statement in SQL?
From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 1998/09/02
Message-ID: <6sjd03$6oj$2_at_relay1.dsccc.com>#1/1
Date: 1998/09/02
Message-ID: <6sjd03$6oj$2_at_relay1.dsccc.com>#1/1
select name
from customers
[Quoted] where custid exists (select parentid
from customers)
[Quoted] Bob Cunningham (bcunn_at_oanet.com) wrote:
: On Tue, 01 Sep 1998 17:30:40 -0700, Troy Perchotte <max_at_headroom.com>
: wrote:
: >How do I include a condition within a select statement?
: >Something like the following (only one that works):
: >
: >select if(customers.custid=customers.parentid,'',customers.name) as
: >parent_name from customers;
: >
: >Troy Perchotte
: >
: >
: You can use the DECODE function. E.g.:
: SELECT DECODE(custid,parentid,NULL,name) parent_name FROM customers;
: Bob Cunningham
: bcunn_at_oanet.com
-- While DSC may claim ownership of all my ideas (on or off the job), DSC does not claim any responsibility for them. Warranty expired when you opened this article and I will not be responsible for its contents or use.Received on Wed Sep 02 1998 - 00:00:00 CEST