Section: Read and filter rows

Select all columns

sql
sql
SELECT * FROM users;
Explanation

Convenient interactively, but explicit column lists are often better for apps and stable contracts.

Learn the surrounding workflow

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

Related commands

Same sheet · prioritizing Read and filter rows
Select only needed columns
Return a smaller projection.
OpenIn sheetsqlsame section
Filter with WHERE and LIKE
Find rows by pattern.
OpenIn sheetsqlsame section
Sort and limit results
Get recent rows first.
OpenIn sheetsqlsame section
Paginate with LIMIT and OFFSET
Fetch one page of rows.
OpenIn sheetsqlsame section
Insert one row
Add a new record.
OpenIn sheetsql1 tag match
Insert multiple rows
Add several records in one statement.
OpenIn sheetsql1 tag match