SELECT

Updated on 2025-01-20 GMT+08:00

View PDF

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.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel