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

No comments:
Post a Comment
leave your comments here..