如何找到一个具有负值而另一个具有相同正值的记录
16lz
2021-01-22
how do I find records that one has a negitive value and the other the same positive value. I have tried this and things like it but they are not working.
如何找到一个具有负值而另一个具有相同正值的记录。我试过这个和类似的东西,但他们没有工作。
where [Check_Number]=[Check_Number] and Payment_Amount = ([payment_amount]/-1)
1 个解决方案
#1
0
How about this:
这个怎么样:
where a.check_Number + b.check_number = 0 and a.check_number < 0
Or, are the two fields payment_amount and check_number?
或者,两个字段payment_amount和check_number?
where payment_amount = - check_number and check_number < 0
Maybe something like this?
也许是这样的?
select r1.check_number, r1.payment_amount, r2.check_number, r2.payment_amount
from records r1 join
records r2
on r1.check_number = r2.check_number and
r1.payment_amount = - r2.payment_amount
更多相关文章
- SQL Server表中某些字段含有水平制表符、换行符、回车符、反斜杠
- fmdb 数据库升级1-----增加表字段
- 如何在postgres中更新时间戳字段的一部分?
- mysql关键字与表名字段相同的解决方法
- Sailsjs Mysql ORM在同一个表字段上进行多次查询
- 如何将表(及其行,列和单元格)保存在SQL数据库的单个字段中
- oracle --sql--转换表字段日期格式(年月日时分秒转换年月日)
- MySQL字段名与保留字冲突
- 写SQL语句,如何找到部分字段内容一样的两条记录?实现调货的功能