今天要做一个结果集的显示,统计所有金额,然后按照已多到少排序,最后要前五条数据。写的时候发现是先rownum在排序的。然后改了改,记下来
*select from (select q.userid username, sum(xjhb) yzje
from t_qt_sj_sjhdgl s, t_qt_sj_sjhdgl_sqjlb q
where s.hdlx in (‘51’, ‘52’, ‘53’, ‘54’)
and s.isdelete = ‘0’
and q.dqlc = ‘ywc’
and q.isdelete = ‘0’
and s.code = q.hdid
group by q.userid
order by yzje desc)tt where rownum<=5**