Select
The SELECT
statement is used to query data from a single table
For example to select all fields from commits table.
Or Selecting just title and message
You can use Aggregation function in the select statement to perform function on all data until the current one
You can alias the column name only in this query by using as
keyword for example
SELECT title as tt FROM commits
SELECT name, commit_count, max(commit_count) AS max_count message FROM branches
You can select unique rows only using the distinct
keyword for example,