SELECT and FROM basics

Concepts: sqlSelectFrom

Every SQL query follows a predictable structure that tells the database what data you want and where to find it. Building Your First Query Understanding the role of each keyword helps you construct queries that retrieve exactly the data you need. SELECT Columns FROM Arrange the Query Check Your Understanding Selecting only the columns you need, rather than all columns, reduces the amount of data the database must read and transfer, which makes queries faster on large tables.