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, 1257🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...