小弟想将一下代码中sql的SQL语句改成Qracle的SQL语句,不知该如何改写,求师傅帮忙。问这样的问题实在是很无奈,希望哪位师傅能帮一下忙。
wsprintf(sqlstatement,
"select TOP %d * from %s "
"where TransFlag = 1 or TransFlag = 3", nMaxCount, sTable);
wsprintf(sqlstatement,
"select TOP %d * from %s "
"where TransFlag = 1 or TransFlag = 3", nMaxCount, sTable);
"where TransFlag = 1 or TransFlag = 3",
这个是SQL语句,上面%d,%s都是变量
select * from %s
where TransFlag = 1 or TransFlag = 3 and rownum=%d