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, 1764🔥, 2💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...