一句关于数字比较的sql语句

[areslong]

if je="1" then
sql="select * from su where xy-xy2='0' order by sj desc"
end if

if je="0" then
sql="select * from su where xy-xy2>'0' order by sj desc"
end if
...

其中的xy，xy2多是int类型

[dh20156]

参考HAVING子句

[danis_cn]

sql="select * from su where xy-xy2=0 order by sj desc"
或者
sql="select * from su where xy=xy2 order by sj desc"

[diyager]

结吧

[areslong]

不行啊,老大！！