SELECT

The syntax of a complete analysis statement is as follows:

 SELECT [DISTINCT] (* | expression) [AS alias] [, ...]
[GROUP BY expression [, ...] [HAVING predicates]]
[ORDER BY expression [ASC | DESC] [, ...]]
[LIMIT size OFFSET offset]
 

SELECT indicates the field to be queried. The following part describes parameters and examples for the SELECT syntax.

Using * to query all fields.

 SELECT *
 

**Table 1** Using * to query all fields
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
 

**Table 2** Querying a specified field
firstname	lastname
Amber	Duke
Hattie	Bond
Nanette	Bates
Dale	Adams

Using AS to Define Field Aliases

 SELECT account_number AS num
 

**Table 3** Using AS to define field aliases
num
1
16
13
18

Using the DISTINCT Statement

 SELECT DISTINCT age
 

**Table 4** Using the DISTINCT statement
age
32
36
28

Using SQL Functions

For details about functions, see Functions.

 SELECT LENGTH(firstname) as len, firstname
 

**Table 5** Using SQL functions
len	firstname
4	Amber
6	Hattie
7	Nanette
4	Dale

Parent topic:Analysis Statements

Previous topic: Analysis Statements

Next topic: GROUP BY

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.