SQL Exercises: Display the numbers in columns

Last update on September 24 2025 10:33:40 (UTC/GMT +8 hours)

3. Display Three Numbers

Write a SQL query to display three numbers in three columns.

Sample Solution:

-- This query selects three numeric literals (5, 10, and 15) as separate columns.
SELECT 5, 10, 15;

Output of the Query:

?column?
15

:Code Explanation:

The above query in SQL that selects a row with three columns, each with a different value: 5, 10, and 15. These values will be in a single row and multiple columns.

Visual presentation:

Go to:

• SQL Retrieve data from tables Exercises Home ↩
• SQL Exercises Home ↩

PREV : Display a Custom String.
NEXT : Sum of Two Numbers.

Practice Online

For more Practice: Solve these Related Problems:

• Write a SQL query to display three numbers: 10, 20, and 30 in separate columns.
• Write a SQL query to show the numbers 5, 15, and 25 in three different columns.
• Write a SQL query to display the values 7, 14, and 21 in three distinct columns.
• Write a SQL query to output the numbers 100, 200, and 300 in separate columns.

Have another way to solve this solution? Contribute your code (and comments) through Disqus.