题目要求是：
按部门降序排列，每个部门号只显示一次，且不同部门的员工信息显示时间隔2个空行。
请问这个如何设置啊？我刚学oracle。
除了select department_id from xxx order by department_id desc
break on department_id
还应该增加什么语句？
谢谢！

补充 SELECT DISTINCT depart_id

department_id后面加回车看看，
select DISTINCT department_id,chr(10)from xxx order by department_id desc

SELECT DISTINCT depart_id

select DISTINCT department_id from xxx order by department_id desc