public inbox for [email protected]
help / color / mirror / Atom feedFrom: Mehmet Sabri KUNT <[email protected]>
To: JORGE MALDONADO <[email protected]>
Cc: [email protected]
Subject: Re: Query with conditional statement
Date: Thu, 14 Sep 2023 11:11:30 +0300
Message-ID: <CAKrVsE_A-3Yav4mPCMSGCY6Eg6JA2cTir56a4BBBmGusdSqP8Q@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <DM4PR12MB511902103147E02227761C66D2F0A@DM4PR12MB5119.namprd12.prod.outlook.com>
<[email protected]>
Hi Jorge,
You can not use the case statement like in your code.
If you want to get a different field's value by your condition you can use
the case statement like the following examples.
select id,CASE WHEN condition1 THEN fldx1 END AS a1,CASE WHEN
condition1 THEN fldx2 END AS a2,CASE WHEN condition1 THEN fldx3 END AS
a3,CASE WHEN condition2 THEN fldy1 END AS b1,CASE WHEN condition2 THEN
fldy2 END AS b2,CASE WHEN condition2 THEN fldy3 END AS b3FROM
your_table
If you use like above, you have lots of null values.
If you don't have to use column names like a1, a2,a3, b1,b2, or b3 like in
your code, I suggest using like the following
selectid,CASE WHEN condition1 THEN fldx1 WHEN
condition2 THEN fldy1 ELSE aaa1END AS a1,CASE WHEN
condition1 THEN fldx2 WHEN condition2 THEN fldy2 ELSE
aaa2END AS a2,CASE WHEN condition1 THEN fldx3 WHEN
condition2 THEN fldy3 ELSE aaa3END AS a3FROM your_table
Shane Borden <[email protected]>, 14 Eyl 2023 Per, 01:43 tarihinde şunu
yazdı:
> You will need to do a CASE statement for each column. I’m not aware of
> being able to return multiple columns from one case.
>
> Shane Borden
> [email protected]
> Sent from my iPhone
>
> On Sep 13, 2023, at 4:23 PM, Tchouante, Merlin <[email protected]>
> wrote:
>
>
>
> Yes, it can.
>
>
>
> *Thanks,*
>
> * -- Merlin*
>
>
>
>
>
> *Merlin D. Tchouante,* Sr. IT Enterprise Application Developer
> *Center for Information Technology Services (CITS)*
> *601 West Lombard Street*
> *Baltimore, Maryland 21201-1512*
> *[email protected]* <[email protected]>
> 410-706-4489 * 410-706-1500 fax
>
>
>
> *Please send Blackboard questions to the CITS support email address:*
> [email protected] <[email protected]>
>
> *Please send Mediasite questions to the CITS support email address:*
> [email protected]
>
>
>
> <image001.png>
>
>
>
> *From:* JORGE MALDONADO <[email protected]>
> *Sent:* Wednesday, September 13, 2023 1:52 PM
> *To:* [email protected]
> *Subject:* Query with conditional statement
>
>
>
> You don't often get email from [email protected]. Learn why this is
> important <https://aka.ms/LearnAboutSenderIdentification;
>
> *CAUTION: *This message originated from a non-UMB email system. Hover
> over any links before clicking and use caution opening attachments.
>
> Hi,
>
>
>
> Can a conditional CASE statement be part of the SELECT portion of a query?
> For example:
>
>
>
> SELECT
>
> fld1, fld2, fld3,
>
> CASE
>
> WHEN condition1 THEN fldx1 AS a1, fldx2 AS a2, fldx3 AS a3
>
> WHEN condition2 THEN fldy1 AS b1, fldy2 AS b2, fldy3 AS b3
>
> ELSE .....
>
> END,
>
> fld6, fld7
>
> FROM ......
>
> WHERE ......
>
>
>
> I ran a test and see the following:
>
> * Each WHEN only accepts 1 result and not 3 as shown in the example
>
> * The AS for the alias is not supported
>
>
>
> I need to return more than 1 field on each WHEN and also assign an ALIAS.
>
> I very much appreciate your feedback.
>
>
>
> Regards,
>
> Jorge Maldonado
>
>
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Query with conditional statement
In-Reply-To: <CAKrVsE_A-3Yav4mPCMSGCY6Eg6JA2cTir56a4BBBmGusdSqP8Q@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox