Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - "AS" - Naming Query Output Columns
(Continued from previous topic...)
How To Name Query Output Columns?
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
Category Year Counts
SQA 2003 1
DEV 2004 1
DBA 2005 1
DBA 2006 1
DEV 2006 1
DBA 2007 1
SQA 2007 1
(Continued on next topic...)
- How To Join Two Tables in a Single Query?
- How To Write a Query with an Inner Join?
- How To Define and Use Table Alias Names?
- How To Write a Query with a Left Outer Join?
- How To Write a Query with a Right Outer Join?
- How To Write a Query with a Full Outer Join?
- How To Write an Inner Join with the WHERE Clause?
- How To Name Query Output Columns?
- What Is a Subquery in a SELECT Query Statement?
- How To Use Subqueries with the IN Operators?
- How To Use Subqueries with the EXISTS Operators?
- How To Use Subqueries in the FROM Clause?
- How To Count Groups Returned with the GROUP BY Clause?
- How To Return the Top 5 Rows from a SELECT Query?
- How To Return the Second 5 Rows?
- How To Use UNION to Merge Outputs from Two Queries Together?
- How To Use ORDER BY with UNION Operators