How To Name Query Output Columns?
Page 1 of 1
How To Name Query Output Columns?
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,
MAX(salary) AS High, AVG(salary) AS Average
FROM employees GROUP BY department_id HAVING AVG(salary) < 5000;
ID LOW HIGH AVERAGE
---------- ---------- ---------- ----------
30 2500 11000 4150
50 2100 8200 3475.55556
10 4400 4400 4400
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,
MAX(salary) AS High, AVG(salary) AS Average
FROM employees GROUP BY department_id HAVING AVG(salary) < 5000;
ID LOW HIGH AVERAGE
---------- ---------- ---------- ----------
30 2500 11000 4150
50 2100 8200 3475.55556
10 4400 4400 4400
Similar topics
» Can the Query Output Be Sorted by Multiple Columns?
» How To Sort the Query Output?
» How To Divide Query Output into Groups?
» How To Set Up SQL*Plus Output Format?
» How To Select Some Columns from a Table?
» How To Sort the Query Output?
» How To Divide Query Output into Groups?
» How To Set Up SQL*Plus Output Format?
» How To Select Some Columns from a Table?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Sun Jan 31, 2010 12:35 am by Micheal
» Accessing tables of other users in SQL
Sun Jan 31, 2010 12:34 am by Micheal
» Grouping commands in SQL
Sun Jan 31, 2010 12:32 am by Micheal
» Operations on Result Sets in SQL
Sun Jan 31, 2010 12:31 am by Micheal
» Subqueries in SQL
Sun Jan 31, 2010 12:30 am by Micheal
» Joining Relations in SQL
Sun Jan 31, 2010 12:28 am by Micheal
» Delete comand in SQL
Sun Jan 31, 2010 12:27 am by Micheal
» Update command in SQL
Sun Jan 31, 2010 12:26 am by Micheal
» Insert command in SQL
Sun Jan 31, 2010 12:23 am by Micheal