Reading data

Write the query to list records with SELECT.

With the table in place we can read data. We list records from the notes table with SELECT.

SELECT id, title FROM notes;

This returns the id and title of all notes.

id, title is selected from notes.

Reading data — details

Read is the R in CRUD. With SELECT you choose columns and rows. Here we list all notes; later we will fetch a single note.

Select id and title from the notes table.

Show example solution

SELECT id, title
FROM notes

All notes

SELECT id, title ____ notes;

Show answer

SELECT id, title FROM notes;