SELECT Statement Basics

This lesson covers the basics of the SQL SELECT statement — the most fundamental way to pull data out of a table. It's written for anyone searching "SQL SELECT tutorial" or "SQL for beginners."

SQL is a language for retrieving data stored in database tables. The basic shape is SELECT column FROM table — think of it like pulling out just the columns you need from a spreadsheet. SELECT * retrieves every column.

The example creates a students table, inserts three rows, then runs SELECT * FROM students; to fetch every column and row. In one snippet, you can see the whole flow: create a table, add data, then query it.

A common early mistake is mixing up the order of SELECT and FROM — it's always "what (SELECT)" then "from where (FROM)." Getting this basic pattern into muscle memory is the first real step in learning SQL, since nearly every database behind a web service is queried this way, thousands of times a day.