SQL returning string instead table

Question

I am having this SQL command:

Select company, purchases.stock,SUM(ammount)*price from purchases INNER JOIN curstock ON purchases.stock = curstock.stock Group by company , purchases.stock;

Which returns following table :

Is it possible that it would print instead of table strings like: "Company XXX owns YYY in ZZZ stock."

or SQL does not provide such formatting and it has to be done in code.

Ferdinand Gaspar · Accepted Answer · 2017-08-22 23:16:47Z

4

You can use CONCAT() function

SELECT CONCAT('Company ', company, ' owns ', SUM(ammount)*price, ' in ', purchases.stock, ' stock.') AS value
  FROM purchases 
 INNER JOIN curstock 
    ON purchases.stock = curstock.stock 
 GROUP BY company , purchases.stock;

answered Aug 22, 2017 at 23:16

Ferdinand Gaspar

2,0831 gold badge10 silver badges17 bronze badges

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

5 Comments

PapeK24 Over a year ago

Thanks , this is exactly what I was looking for. This function is specific to MYSQL tho isn't it? (Not that it would be problem because it is one I am using right now.)

Ferdinand Gaspar Over a year ago

Yes it is. CONCAT() function in MySQL automatically converts numbers to string so no need to convert them as oppose to MS SQL or Oracle which needs to use CAST() or TO_CHAR() respectively.

PapeK24 Over a year ago

Is there also any option doing this in OPENSQL standard? that you know of?

Ferdinand Gaspar Over a year ago

I think ABAP OpenSQL also has CONCAT() function.

Ferdinand Gaspar Over a year ago

@LAS He is using MySQL as tagged in his question.

Collectives™ on Stack Overflow

SQL returning string instead table

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related