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, 1782🔥, 2💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...