"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

 

What Is a Subquery in a SELECT Query Statement in SQL Server

Writing Inner Joins with the WHERE Clause in SQL Server

Using SELECT Statements with Joins and Subqueries in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-29, 1266🔥, 0💬