select.md

Select Statement

The SELECT statement is used to query data from a single table

For example to select all fields from commits table.

SELECT * FROM commits

Or Selecting just title and message

SELECT title message FROM commits

You can use Aggregation function in the select statement to perform function on all data until the current one

SELECT count(name) FROM commits

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

---

Distinct option

You can select unique rows only using the distinct keyword for example,

SELECT DISTINCT title AS tt FROM commits

---

Distinct On option

You can select rows with unique fields using the distinct on keyword with one or more field for example,

SELECT DISTINCT ON (name) title AS tt FROM commits