Reading Data

SELECT

SELECT reads data from a table.

Syntax:

SELECT column1, column2 FROM table_name;

SELECT name, marks FROM students;

Output

name  | marks
------+------
Ali   | 85
Sara  | 92
Bilal | 78

SELECT * FROM students;                       -- every column
SELECT name AS student_name FROM students;    -- rename a column
SELECT DISTINCT city FROM students;           -- unique values only