PostgreSQL SyntaxLesson 17Free preview

PostgreSQL SELECT

This lesson is part of PostgreSQL · All levels

Summary

SELECT is the core command to read data from one or more tables. You specify what columns are shown in the column list, then you specify the data source in the FROM clause. The addition of WHERE, ORDER BY, and LIMIT allows results to be filtered, sorted, and numbered.

Key points

SELECT specifies the column or expression that appears on the result.
FROM specifies the table of data sources to be read.
The expression of the calculation can be directly displayed by the alias via US.
The combination of SELECT, FROM, WHERE, ORDER BY, and LIMIT is the most common pattern.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.