The SELECT command allows us to specify a particular column or columns from the database table, returning a list of records with the data:

SELECT column_name1, column_name2 FROM table_name 

It can also allow us to select all of the items, using this command:

SELECT * FROM table_name