🐘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

Select first_name, last_name from customer

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

Select * from customer

3) Using PostgreSQL SELECT statement with expressions

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