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.

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

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Liked this content?. Please spread the word :)

  • RSS
  • Twitter
    Visit Us
    Follow Me