select * from bus_news_class c, bus_news_info iwhere c.news_classid=i.news_classidconnect by c.news_parentid=c.news_classidstart with c.news_parentid=3order by c.news_parentid,c.news_classid

sql server:sql server solution1:select top10 * from table where id not in(select top 30 id from t order by id) order by idsql server solution2:select top 10 * from table where id in(select top

String sql = "{call INIT_SORT()}";          CallableStatement cs = null;        Connection conn = null;        ResultSet rs = null;     try {            conn = SessionFactoryUtils.getD