sql 多条件模糊查询例子

select * from A_tabl a where a.status like ?

and a.trdate between ? and ? and(a.name like ? or a.id in(select id from B_tbl where clid like ?) or a.id2 in (select id from B_tbl where clid like ?))

order by clid,trdate desc;

说明：查询同时满足a.status,a.trdate 以及满足a.id 或者a.id2的条件的所有数据，涉及到分页请用hibernate或者自己根据选择数据库添加分页语句。

2013-12-18