How to get specific columns from a Table in SQL Query ?

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

Tags : How to, Query, SQL Server, tips, tricks

Abundant Code