How to display percentages in SQL?

In SQL, to display numbers as percentages, you can use the following two methods:

1. Using the formatting function:
   The FORMAT function can be used in a SELECT statement to convert numbers into percentage display. For example, using the FORMAT function, the number can be divided by the total and multiplied by 100, and then displayed as a percentage with a percent sign.

SELECT FORMAT(column_name/total * 100, 2) AS percentage
FROM table_name;

In the code above, ‘column_name’ is the name of the column to be displayed as a percentage, ‘total’ is the total value, and 2 indicates that it should be rounded to two decimal places.

1. In a SELECT statement, you can indicate percentages by directly multiplying the number by 100 and adding a percentage sign afterwards.

SELECT column_name * 100 AS percentage
FROM table_name;

In the code above, “column_name” is the name of the column to be displayed as a percentage.