How to return extra dynamic column based on query?

Question

I want to return extra dynamic column based on some query. Suppose i have a table named as Table_A having columns A,B,C

If i want to return extra column i will do as below

SELECT A,B,C,D=1
FROM Table_A

D is the extra column with 1 value. Is there any way to put query on D like:

Select SELECT A,B,C,D = (//i want to put query which will return 1 or 0) FROM Table_A

Can i do this?

The best answer depends on specific details you haven't provided. You might be able to use a CASE expression. You might be able to use a query inline. Maybe you need to join another table or use a subquery. There aren't really enough details to answer your question more than "Yes, you can do it." Post your query, a sample of your data, and your desired results. — Bacon Bits
– Bacon Bits, Commented Dec 28, 2015 at 7:20

Pரதீப் · Accepted Answer · 2015-12-28 07:19:49Z

1

Yeah like this

SELECT A,
       B,
       C,
       (SELECT somecol
        FROM   sometable
        ORDER  BY somecol
        limit 1) AS D
FROM   Table_A

LIMIT: To avoid sub-query returns more than one row if any

answered Dec 28, 2015 at 7:19

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Edwin Stoteler · Accepted Answer · 2015-12-28 07:18:52Z

0

You can use a subquery.

SELECT A,B,C, (
   SELECT Some_Column FROM Some_Table) AS D
FROM Table_A

You can also use columns from Table_A in the subquery's where clause. Note that subquery's can lead to bad performance, as they go off for each result row.

answered Dec 28, 2015 at 7:18

Edwin Stoteler

1,2271 gold badge11 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to return extra dynamic column based on query?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related