Query a view

sql

SELECT * FROM recent_posts ORDER BY created_at DESC LIMIT 20;

Explanation

Useful for dashboards and administrative pages.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Create reusable views

Define a reusable read-only query projection.

Open In sheetsqlsame section

Write to an audit log when a row is created.

Open In sheetsql1 tag match

Maintain a timestamp on row changes.

Open In sheetsql1 tag match

Compute a lowercased email for indexing or search.

Open In sheetsql1 tag match

Speed up queries over a derived value.

Open In sheetsql1 tag match