The SELECT command is also the same as PostgreSQL.

Run the following command to see all values in the table (Figure 14):

SELECT * from employees

The CLI will display all entries as follows:

Figure 14 SELECT

Obviously, we can perform a more complex SELECT command. For example:

SELECT employee_name, employee_salary 

FROM employees 

WHERE employee_salary > 18324

The output, as expected, will be Jane Doe and Rachel Roe since their salary is more than 18324. This can be seen in Figure 15.

Figure 15 Conditional SELECT