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, 1775🔥, 2💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...