hibernate:选择前一条或最后一条记录

1、

select t.* from m_business_info t where t.id=(select max(t1.id) from m_business_info t1 where t1.business_type='1' )

 

select rownum,t1.*  from (select t.* from m_business_info t order by t.id desc)  t1 where rownum=1

2、oracle模糊查询中使用索引

select ui."UID" ui_uid, uc.id uc_id, ui.cn/* +index(um_userinfo i_um_userinfo_02) */

from um_userinfo ui, um_user_contact uc
where ui.cn like '黄%'
and uc.borrow_org is null
and ui."UID" = uc."UID"(+)
and ui.pafa_is_active = 'true'

3、有空可以研究下jpcap网络数据包

转载于:https://www.cnblogs.com/xinzhuangzi/archive/2011/01/20/4100470.html