Suggest an editImprove this articleRefine the answer for “How do you select only specific columns?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)To select only specific columns, list the names of the columns you need, separated by commas, in the `SELECT` command, e.g. `SELECT Name, Age FROM Employees WHERE DepartmentID = 101;`. **Key point:** any number of columns can be selected, even just one - if every column is needed, `SELECT *` is used instead, and if only some are, they're listed explicitly.Shown above the full answer for quick recall.Answer (EN)ImageTo select **only specific columns**, list the names of the columns you need in the `SELECT` command, separated by commas. **Syntax:** ```sql SELECT Column1, Column2, ... FROM Table_Name WHERE Condition; ``` **Example:** ```sql SELECT Name, Age FROM Employees WHERE DepartmentID = 101; ``` ### What this query does 1. Pulls only the `Name` and `Age` columns from the `Employees` table. 2. Filters records by the condition `DepartmentID = 101`. **Notes:** - Any number of columns can be selected, even just one. - If every column is needed, `SELECT *` is used, and if only some, they're listed explicitly. > Put simply, this kind of query lets you **get only the data you need**, without cluttering the result with unnecessary columns.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.