SELECT
Specifies the field to be queried.
Using * to query all fields.
SELECT *
account_number |
firstname |
gender |
city |
balance |
employer |
state |
lastname |
age |
---|---|---|---|---|---|---|---|---|
1 |
Amber |
M |
Brogan |
39225 |
Pyrami |
IL |
Duke |
32 |
16 |
Hattie |
M |
Dante |
5686 |
Netagy |
TN |
Bond |
36 |
13 |
Nanette |
F |
Nogal |
32838 |
Quility |
VA |
Bates |
28 |
18 |
Dale |
M |
Orick |
4180 |
null |
MD |
Adams |
32 |
Querying a Specified Field
SELECT firstname, lastname
firstname |
lastname |
---|---|
Amber |
Duke |
Hattie |
Bond |
Nanette |
Bates |
Dale |
Adams |
Using AS to Define Field Aliases
SELECT account_number AS num
num |
---|
1 |
16 |
13 |
18 |
Using the DISTINCT Statement
SELECT DISTINCT age
age |
---|
32 |
36 |
28 |
Using SQL Functions
For details about functions, see Functions.
SELECT LENGTH(firstname) as len, firstname
len |
firstname |
---|---|
4 |
Amber |
6 |
Hattie |
7 |
Nanette |
4 |
Dale |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.