Return all columns from a table.
Section: SELECT Basics
Select all columns
sql
sql
SELECT *
FROM users;Explanation
Good for quick exploration, but prefer explicit columns in production queries.
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 SELECT Basics
Select distinct values
Remove duplicate rows for the selected expression set.
Select literals and expressions
Project computed values directly in the result set.