--要求查询 我院2008.01.01到今天的门诊急诊病人的诊断前十位的疾病名称。（急诊的判断以就诊时间为中午12：00-14：30，晚上17：00-8：00）
select * from (
select zdmc00,sl from (
select zdmc00,count(*) sl from ys_brzdxx where zdrq00>='20080101' and zdrq00<='20080901'
and ((zdsj00>='12:00:00' and zdsj00<='14:30:00') or (zdsj00>='17:00:00' and zdsj00<='23:59:59') or (zdsj00>='00:00:00' and zdsj00<='08:00:00'))
group by zdmc00) order by sl desc) where rownum<=10