SQL Commands

Below I have listed the most common commands that I am using when acquiring data from a database

Selecting a single Column from a table:

This will select the column "Name" from the "People" Table.
SELECT name 
FROM people; 

Selecting multiple columns from a table:

This will select the Name and Birthrate column from the people table.
SELECT name, birthdate
FROM people; 

This will select all columns from a table.
SELECT *
FROM people; 

This will select 10 rows with all columns from a table. 
SELECT *
FROM people
LIMIT 10; 

This will select 10 rows with all columns from a table.
SELECT *
FROM people
LIMIT 10;