> For the complete documentation index, see [llms.txt](https://dev7days.gitbook.io/dev7days/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dev7days.gitbook.io/dev7days/postgres/select.md).

# SELECT

Describe about SELECT command

`SELECT` command is a command that retrieve data from a single table. The basic syntax will be `SELECT <colum_name> FROM <table_name>`PostgreSQL evaluates the `FROM` clause before the `SELECT` clause .

We can query with all of this way

#### 1) Using PostgreSQL `SELECT` statement to query data from one  or multiple column

```sql
Select first_name, last_name from customer
```

#### 2) Using PostgreSQL `SELECT` statement to query data from all columns

```sql
Select * from customer
```

#### 3) Using PostgreSQL `SELECT` statement with expressions&#x20;

```sql
Select first_name || ' ' || last_name as full_name, email FROM customer
```