SELECT 1 + 1
output
2
SELECT 'Hello World'
output
Hello World
SELECT
productName
FROM products
output
productName
-----------
pencil
pen
paper
Mountain Dew
I'd like to point out the data returned is not ordered. In later articles I'll show you how to put the results into any order you may find useful. But for now, let's stick to learning about the SELECT statement.SELECT
productName, price
FROM products
output
productName price
----------- -----
pencil .25
pen .99
paper 1.00
Mountain Dew 1.25
SELECT *
FROM products
output
productName price quantity color
----------- ----- -------- -----
pencil .25 100 yellow
pen .99 73 blue
paper 1.00 500 white
Mountain Dew 1.25 8 green
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (0)