SQL SELECT

Feb 18, 2023

Declare what data we are looking for
Given a table of data. we need to SELECT columns to read

• SELECT column1, column2, FROM mytable; SELECT * FROM mytable;
• SELECT b_id-100, a_id FROM R WHERE a_id = 'a2';
• SELECT * FROM R JOIN S USING (a_id, b_id);

Get distinct result

• SQL JOIN