Select a dummy column with a dummy value in SQL?

Question

I have a table with the following

Table1
col1   col2
------------
 1      A 
 2      B
 3      C
 0      D

Result

col1   col2  col3
------------------
0       D     ABC

I am not sure how to go about writing the query , col1 and col2 can be selected by this

select col1, col2 from Table1 where col1 = 0;

How should I go about adding a col3 with value ABC.

Answer 1

Try this:

select col1, col2, 'ABC' as col3 from Table1 where col1 = 0;

Answer 2

If you meant just ABC as simple value, answer above is the one that works fine.

If you meant concatination of values of rows that are not selected by your main query, you will need to use subquery.

Something liket his may work:

SELECT t1.col1, 
t1.col2, 
(SELECT GROUP_CONCAT(col2 SEPARATOR '') FROM  Table1 t2 WHERE t2.col1 != 0) as col3 
FROM Table1 t1
WHERE t1.col1 = 0;

Actual syntax maybe a bit off though