Skip to content
Advertisement

Adding percentage to number in SQL

I would like to add a percentage sign after a number in SQL.

This is the query I have

I have tried using the format function to change the integer to a string and concatenate the percentage sign, but this doesn’t seem to work

Advertisement

Answer

You can use the following solution using CONCAT:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement