Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications

SELECT with DISTINCT

Q:14
Display the names of all Department without repetition.


SQL> SELECT DISTINCT DEPARTMENT FROM EMPLOYEE;

DEPARTMENT
-------------------------
ACCOUNTS
FINANCE
IT
SALES