Distinct

•Use DISTINCT to delete duplicate rows in table
•The default display of queries is all rows, including duplicate rows

Select department_id from employees;




Select DISTINCT department_id from employees;





0 comments:

Post a Comment