If you want to get the data from the specific columns from a table in your database , you can specify them in the query. For example,
SELECT * FROM HumanResources.Department
This would return the data of all the columns available in the Department table.
If you want to get the data of the specific columns from the Department table , you can specify the column names in the Query.
SELECT Name,GroupName FROM HumanResources.Department
The output of the above query will be