View source for 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:
 <nowiki>
This will select the column "Name" from the "People" Table.
SELECT name 
FROM people; 
</nowiki>


Selecting multiple columns from a table:
 <nowiki>
This will select the Name and Birthrate column from the people table.
SELECT name, birthdate
FROM people; 
</nowiki>


 <nowiki>
This will select all columns from a table.
SELECT *
FROM people; 
</nowiki>


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


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