Collections:
"AS" - Naming Query Output Columns in SQL Server
How To Name Query Output Columns in SQL Server?
✍: FYIcenter.com
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
2016-10-29, 1247🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...