to dy_yong(祥子) 還是有點問題 這樣 select ERROR_CODE_STR,count(ERROR_CODE_STR) as g from dbuser.ecs_sfis_code_tmp where site_num =5 group by ERROR_CODE_STR order by g desc 可以案 g 從大到小的順序顯示現在我要取出排名前10 的紀錄select ERROR_CODE_STR,count(ERROR_CODE_STR) as g from dbuser.ecs_sfis_code_tmp where rownum<=10 site_num =5 group by ERROR_CODE_STR order by g desc 就不行怎麼回事好想對有group by 限制的sql就不行麻煩了
還是有點問題
這樣
select ERROR_CODE_STR,count(ERROR_CODE_STR) as g
from dbuser.ecs_sfis_code_tmp
where site_num =5
group by ERROR_CODE_STR
order by g desc
可以案 g 從大到小的順序顯示現在我要取出排名前10 的紀錄select ERROR_CODE_STR,count(ERROR_CODE_STR) as g
from dbuser.ecs_sfis_code_tmp
where rownum<=10 site_num =5
group by ERROR_CODE_STR
order by g desc
就不行怎麼回事好想對有group by 限制的sql就不行麻煩了