Collections:
Name Query Output Columns in Oracle
How To Name Query Output Columns in Oracle?
✍: 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:
SQL> SELECT department_id AS ID, MIN(salary) AS Low, 2 MAX(salary) AS High, AVG(salary) AS Average 3 FROM employees GROUP BY department_id 4 HAVING AVG(salary) < 5000; ID LOW HIGH AVERAGE ---------- ---------- ---------- ---------- 30 2500 11000 4150 50 2100 8200 3475.55556 10 4400 4400 4400
⇒ What Is a Subquery in Oracle
⇐ Left Outer Join with the WHERE Clause in Oracle
2019-09-27, 1855🔥, 2💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...