Compound Aliase in SELECT Oracle Example

How To Use Compound ALIASE in SELECT Oracle Database Tutorial Example

Run Query Editor then copy & paste the below code to use Compound Aliase in SELECT keyword from a table in Oracle Database Server Tutorial Example

   -- CONNECT AS HR

   SELECT COUNT(1) AS "Combine Total"
   FROM ( SELECT DISTINCT DEPARTMENT_ID,SALARY FROM EMPLOYEES );
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Use Compound ALIASE in SELECT Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..