陕西海天制药官方网站:SQL语句问题

来源：百度文库编辑：杭州交通信息网时间：2024/04/29 14:30:14

帮我看一下这个
sql = "select * from gsecnewsinfo where newsid in (select newsid from ( select newsid, rownum as con from ( select newsid from gsecnewsinfo ";
if(!strCateID.equals("0")){
sql += " where cateid = '" + strCateID +"'";
}
sql += " order by checked,createtime desc )";
sql += " where rownum <= " + (currentPage)*pageSize +")";
sql += "where con >" +(currentPage-1)*pageSize + ") order by checked,createtime desc";

如果要再加一个WHERE，条件，，怎么加？
加上where newstitle like '%2005%'

最后一句
sql += "where con >" +(currentPage-1)*pageSize + ") order by checked,createtime desc";

改成:
sql += "where con >" +(currentPage-1)*pageSize + ") and newstitle like '%2005%'
order by checked,createtime desc";

SQL语句问题 SQL语句问题 SQL语句问题有关SQL语句问题 sql语句问题 sql语句问题access sql语句查询问题 sql数据库语句问题 SQL语句问题 SQL语句问题