Overview
To expand on the previous tutorial, multiple columns can be accessed from a single SELECT statement. In this circumstance we will select a few different columns from a table and all of the associated rows will be returned. Let’s take a look at a simple example.
Explanation
In the example below we are selecting the EmployeeID, LoginID and HireDatecolumn columns from the HumanResources.Employee table. Here is the sample code:
USE AdventureWorks;
GO
SELECT EmployeeID,
LoginID,
HireDate
FROM HumanResources.Employee;
GOBelow is the sample result set:
Jeremy Kadlec is a Founder, Editor and Author at MSSQLTips.com with more than 300 contributions and 25+ years of SQL Server experience. Jeremy leads a team of more than 300 authors helping millions of SQL Server professionals around the globe every second of the day for the last 20 years. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP based on his community contributions. Jeremy brings 25+ years of SQL Server DBA and Developer knowledge to the community and holds a bachelor’s degree from SSU and master’s degree from UMBC.
