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
2019-09-27, 995👍, 2💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...