Oracle - Name Query Output Columns in Oracle

Name Query Output Columns in Oracle

Q

How To Name Query Output Columns in Oracle?

✍: FYIcenter.com

A

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

⇒Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2019-09-27, 995👍, 2💬

💬 2019-09-19 Aninda mahadev: Good Tutorial!!!

What Is a Subquery in Oracle
What Is a Subquery in Oracle? A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The output of the subquery will be used in the final eval... 2019-09-27, 870👍, 0💬

Inner Join with the WHERE Clause in Oracle
How To Write an Inner Join with the WHERE Clause in Oracle? If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example: SQL> SELECT d.department_name, e.first_name, e.last_name 2 FROM... 2019-10-18, 843👍, 0💬

Left Outer Join with the WHERE Clause in Oracle
How To Write a Left Outer Join with the WHERE Clause in Oracle? If you don't want to use the LEFT OUTER JOIN ... ON clause to write a left outer join, you can use a special criteria in the WHERE clause as "left_table.column = right_table.column(+)". The select statement below is an example of a left... 2019-10-18, 827👍, 0💬

Use Subqueries with the IN Operator in Oracle
How To Use Subqueries with the IN Operator in Oracle? A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you how to ... 2019-09-27, 736👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.