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

Published on August 14, 2016 by abundantcode

Filed under SQL Server

Last modified August 14, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 2 (1 votes)

This article have been viewed 4386 times

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.

SNAGHTMLc08547

 

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

image

Leave a Comment


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...