"AS" - Naming Query Output Columns in SQL Server

Q

How To Name Query Output Columns in SQL Server?

✍: FYIcenter.com

A

Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows you a good example:

SELECT tag AS Category, YEAR(created) AS Year, 
   COUNT(*) AS Counts FROM fyi_links 
   GROUP BY tag, YEAR(created) ORDER BY COUNT(*) DESC
GO
Category   Year   Counts
SQA        2003   1
DEV        2004   1
DBA        2005   1
DBA        2006   1
DEV        2006   1
DBA        2007   1
SQA        2007   1

 

Using SELECT Statements with Joins and Subqueries in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-29, 621👍, 0💬