---
description: Describe about SELECT command
---

# SELECT

`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
```
