SELECT DISTINCT Combine Unique Data in Oracle

How To SELECT Combine Unique Data DISTINCT Oracle Database Tutorial Example

Run Query Editor then copy & paste the below code to SELECT combine unique data using DISTINCT keyword from a table in Oracle Database Server Tutorial Example

   -- CONNECT AS HR
   -- Let's view how many combine unique DEPARTMENT and SALARY data in HR.EMPLOYEES table

   SELECT DISTINCT DEPARTMENT_ID, SALARY FROM EMPLOYEES;

      -- That's it!! DISTINCT(Unique) Combine DEPARTMENT and SALARY data have been selected in oracle database
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To SELECT Combine Unique Data DISTINCT Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..