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, 3482🔥, 2💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...