w3resource
Run SQL Query

SQL: Display the numbers in columns

SQL Basic Select Statement: Exercise-3 with Solution

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

Sample Solution:

SELECT 5, 10, 15;

Output of the Query:

?column?
15

:Explanation:

Syntax of display numbers in columns

Pictorial presentation:

Result of display numbers in columns


Practice Online


Query Visualization:

Duration:

Query visualization of Display numbers in columns - Duration

Rows:

Query visualization of Display numbers in columns - Rows

Cost:

Query visualization of Display numbers in columns - Cost

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

Previous: Write a query to display a string "This is SQL Exercise, Practice and Solution".
Next: Write a query to display the sum of two numbers 10 and 15 from RDMS sever.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



Share this Tutorial / Exercise on : Facebook and Twitter

SQL: Tips of the Day

Can a foreign key be NULL and/or duplicate?

First remember a Foreign key simply requires that the value in that field must exist first in a different table (the parent table). That is all an Foreign key is by definition. Null by definition is not a value. Null means that we do not yet know what the value is.

Ref: https://bit.ly/3uVu3OS