How to include dollar sign in integer number?

Hi there,

I was just wondering how to include the dollar sign in the SQL query result from exercise 3 in this project?

My SQL is:

SELECT SUM(valuation)
FROM startups;

it currently returns an integer number with no dollar sign.

Kind Regards,

Jimmy

Hello @jimmywijaya, you could always name the column something in dollars, so that the figures are known to be in dollars:

SELECT column_name AS alias
FROM table; 

This explains alias.
I hope this helps!

Hi @codeneutrino,
Thanks for your reply, but that is not exactly what I am looking for.
I’m looking for a way to generate $ sign in the query result without having to mention in the ALIAS.
Tried to google but there is no clear way for me to achieve it.

Regards,
Jim

Hello @jimmywijaya. There is a function CONCAT, which might be able to help you. Here is a link that might help you to understand the CONCAT function.
I hope this helps!

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.