Resolved: SQL: Select AS with IF condition

In this post, we will see how to resolve SQL: Select AS with IF condition

Question:

I have a MSG table with columns ITEM_ID, SELLER_ID, MSG_SENDER_ID and MSG_RECEIVER_ID to record the conversation between a buyer and seller for an item.

ITEM_ID	SELLER_ID	MSG_SENDER_ID	MSG_RECEIVER_ID
5	1	1	2
5	1	2	1

I need to select SELLER and BUYER. In this case seller = 1 and buyer = 2. The logic is: if SELLER_ID == MSG_SENDER_ID then buyer = MSG_RECEIVER_ID. then if SELLER_ID == MSG_RECEIVER_ID then buyer = MSG_SENDER_ID.
What should the query be like?

Best Answer:

Are you looking for this?

SELECT *
      ,CASE 
            WHEN SELLER_ID = MSG_SENDER_ID THEN 'buyer'
            WHEN SELLER_ID = MSG_RECEIVER_ID THEN 'seller'
        END AS type
FROM MSG

If you have better answer, please add a comment about this, thank you!

Source: Stackoverflow.com

Resolved: SQL: Select AS with IF condition

Resolved: How to stop a thread that has a blocking function from easygui in python

Resolved: Removing null keys from a json array of objects

Resolved: How can I generate at compile-time a separate OpenAPI Swagger.json file for each Controller in my ASP.NET project?

Question:

Best Answer:

Related Posts

Resolved: How to stop a thread that has a blocking function from easygui in python

Resolved: Removing null keys from a json array of objects

Resolved: How can I generate at compile-time a separate OpenAPI Swagger.json file for each Controller in my ASP.NET project?